Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5527 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
How to restrict password to a user while sending a document in .pdf format
Explain in detail about type 1?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Is there any other repository domains rather than universe, security, document?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain what are the steps to be taken to schedule the report?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain how to schedule the report in b.o?
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)?
Explain about alerts in bos, under what situation we need to use alerts?
Did you face any problems while creating reports? Name? Solutions?
any difficulitis have you phase while creating bo reports and how did u solve it
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
