Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

can anyone help me ? an index has been done on the primary
key of a table. an update operation was performed on that
table. now my question is 1> what abt the performance ?
means faster or slower due to indexing ? 2> does the
operation affect to the primary key constraint ?
normally database take to refresh time 2 hours. but client
asked iwant to refresh with in 5 min that same database. do
you have any option in BO and Oracle? explain me briefly...kavi

Question Posted / kavi

Answers were Sorted based on User's Feedback



can anyone help me ? an index has been done on the primary key of a table. an update operation was ..

Answer / janardhan.g

when we use an INDEX..performance will increases.........
Infact the main purpose of index is to increase the
performane only...(very fast).
2.the index ,genarally works based on primary key or unique
key.
when we use index..refreshing time will reduces..

ITS a database question...its no way related to BO.

Is This Answer Correct ?    3 Yes 0 No

can anyone help me ? an index has been done on the primary key of a table. an update operation was ..

Answer / manoj

of course if you have index and you want to refresh, it
will take lot of time because every time the row is gettig
refreshed index is refreshed and will take lot of time.
For best practice while refreshing disable the index after
refresh enable the index that will improve your performance.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Business Objects Interview Questions

what r the universe connection types?

4 Answers  

is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?

3 Answers  

HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?

5 Answers   HCL,

date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2

1 Answers   Honeywell,

CAN A REPOSITORY CONTAINS REPORTS?

7 Answers   AG Technologies,

what are slowly changing dimensions, confirm dimensions?

1 Answers   Wipro,

what is optional prompt in boxi r2

4 Answers   Mind Tree,

What are the steps to taken care to improve the Report performance?

3 Answers  

what is profile and packages in BOXI??

1 Answers  

Explain which versions are used in the bo dashboard work?

0 Answers  

1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?

2 Answers   TCS,

The business object 6.5 version is possible for created dashboard reports.if possible how is generated universe to dashboard reports

1 Answers  

For more Business Objects Interview Questions Click Here
Categories