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
- 2 Answers
- 4581 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Which versions are used in the bo dashboard work?
What would you consider as your biggest achievement and why?
Explain the difference between union and group?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
How we drill up week to month?
Explain about a time when you discovered a more efficient way to do a work task?
how to create reports on screech?
Explain how many universes can be created in a project?
What is the difference between condition & filter?
What sort of existing documents should business analysts refer to when starting on a new project?
what is universe null
What three things do you consider to be the most important factors for a manager?
Explain what are the steps to be taken to schedule the report?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
