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
- 5430 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 |
Can anybody tell How a report will burst into .pdf files? Thanks in advance .....Prakash
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?
What is the strategies ? what is the need of the strategies?
what is tuning of business reports ?
5 Answers Business Intelligence Analytics, Oracle, TCS,
Can Bo generates the reports from cubical data ? Explain?
Explain about a time when you discovered a more efficient way to do a work task?
How will you know the version of Bo using designer?
4 Answers Tavant Technologies,
How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?
what are slowly changing dimensions, confirm dimensions?
can anybody tell me about issues faced while creating reports
What is sdlc in bo?
Teradata 
