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
- 4577 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain what are the steps to be taken to schedule the report?
Explain is data mart?
Difference between b.o 5.1 and 6.1b?
How to generate the report from excel sheet?
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.
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Explain how we drill up week to month?
What is the difference between datawarehousing and businessintelligence?
What are the steps to be taken to schedule the report?
how to create reports on screech?
Explain is there any default username & pwd for bo designer & supervisor?
What are the data types present in bo? What happens if we implement view in the designer and report?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
What is the difference between slice and dice and cross tab report?
Difference between zabo and webi?
