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
- 5448 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 can you first report in Business Objects by using broadcast agent?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Explain in detail about type 2(scd),
What is Indexing? how did u implement indexing?
Explain how we drill up week to month?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Can more than 1 metric be applied on an analytic in business objects?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Explain the difference between detect alias and detect context?
Explain what is the difference between slice and dice and cross tab report?
What are all difference between business objects 6.5 and xi r2?
Explain the data types present in bo and what happens if we implement view in the designer and report?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Can you please send me the migration related issues .
