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 |
How you get the requirement from client?
How to create predefined filters in B.O.
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....
IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Can anyone tell me how to display (calculate )Turn Around Time between two dates in the BO Report? Thanks in Advance
What are templates? Explain what you have created?
What is mean by stored procedure ? and how we can generate stored procedure universe?
What would you consider as your biggest achievement and why?
What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...
Explain about a tricky situation for which you found a very simple solution?
Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.