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
- 5445 Views
- iFlex, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?
what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
What is meant by multiple data provider.How to use it in universe as well as reporting environment?
REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.
I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?
How to resolve the partial result error in the report
What are all difference between business objects 6.5 and xi r2?
how to limit number of rows in a report in business objects using webi?
How to schedule the report in b.o?
What are the steps to taken care to improve the Report performance?
Explain 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)?
Teradata 
