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

5.what is LOV? where it is store?

3 Answers   TCS,

Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.

2 Answers   Cap Gemini, Infinity, TCS,

Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?

1 Answers  

my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it

1 Answers  

what is drill down?

5 Answers   TCS,




What is meant by ZABO and FC(full-client)?

2 Answers  

Is import wizard, report conversion tool, report comparison tool, security viewer ---- where all r migrating tools. whether all the tools available in BOXIR2? ..

2 Answers  

How to Shedule the reports in Xi R2

3 Answers   iFlex,

What is the difference between the prompt and cascading prompt

2 Answers  

Is it necessary to give joins to the aggrigate tables in the universe?

2 Answers  

2.What is loop? How resolve the loop?explain it?

11 Answers   TCS, UHG,

how many user were there

1 Answers  

For more Business Objects Interview Questions Click Here
Categories