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 / 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 about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What are all difference between business objects 6.5 and xi r2?
Can Bo generates the Report from the cubical data Explain?
How to restrict password to a user while sending a document in .pdf format
What is the difference between business requirement document and use case document.
What is the functional & architectural differences between business objects and web intelligence reports?
What is the difference between slice and dice and cross tab report?
What is Indexing? how did u implement indexing?
What is the difference between user and versatile user?
Explain about alerts in bos, under what situation we need to use alerts?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
What is difference between custom hierarchy and report based hierarchy?
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?
Explain the difference between union and group?
Can anybody tell me what are the tuning problems?