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
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
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
What is the difference between user and versatile user?
how to create reports on screech?
Explain when we use aggregate awareness function in designer?
how to create metric universe ?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
What is the profile and package?
Explain when to use local filter and when to use global filter?
Explain what is the difference between business requirement document and use case document.
Explain is there any default username & pwd for bo designer & supervisor?
What is the dense rank?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
how get the grand total in master-detail report?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.