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 / 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 |
Post New Answer View All Answers
What three things do you consider to be the most important factors for a manager?
how many reports have u created ? explain a few.
What is top business?
What is package in BO
What is the difference between datawarehousing and businessintelligence?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
How to create Index to the table in the universe designer and how it improves the Query performence
How would you format some text using css to be verdana and bold?
explain in detail about type 3?
Explain what would you consider as your biggest achievement and why?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Explain how to schedule the report in b.o?
Explain in detail about type 1?