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
- 5390 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 |
What is slicing and dicing in business objects?
what is difference between Rich client web intelligence and Boxir2 web intelligence
How many universes can be created in a project?
Briefly describe the steps you would take to use an Excel file as data to join a Business Objects data provider in a report? Thanks in advance....
HI, can anybody explain me how performence will decrease if we create objects using derived tables ?
Suppose we had a scenerio like in an universe there are nearly 250 objects but only 50 objects data is updated frequently so is there any way to overcome it.(Birla Soft,)
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
where are objects are stored ?
Can anyone tell me how to display (calculate )Turn Around Time between two dates in the BO Report? Thanks in Advance
Can anybody tell me . Is it required CMS Server for Desktop Intelligence Reports?
how to add duplicte rows to the existing report in webi ?
what is meant by slowly changing dimensions?
Teradata 
