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
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 |
Explain what sort of existing documents should business analysts refer to when starting on a new project?
i am using Business Objects 6.1(a) facing a problem. ie when we save report in xls format then in xls sheet pictures are inserted into rep file are not come. Is it a bug. Give me answer as soon as possible. Thanks in Advance
How to execute the MACRO through Infoview?
what is isolated joins in check integrity
what is difference between WEBi Report and Crystal Report?
3 Answers Cognos, Nucleus Software, Red Cross,
Explain the SQL Queries activated to data base from Data provider in BO ?
There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?
What is broad cast agent?
Explain what is the difference between slice and dice and cross tab report?
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
Is it mandatory to give a cardinality ? If cardinality is not given what will happen?
can any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.