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
- 5391 Views
- iFlex, I also Faced
- E-Mail Answers
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 sort of existing documents should business analysts refer to when starting on a new project?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Explain what is the difference between slice and dice and cross tab report?
Differences between business objects and web intelligence reports?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What is top business?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
What is a fantrap in business objects?
Did you face any problems while creating reports? Name? Solutions?
What is package in BO
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
What is the difference in creating filters in designer and business objects?
Explain when we use aggregate awareness function in designer?
what is document design in boxi,have u participate in that
