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
- 5619 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
Explain what are the steps to be taken to schedule the report?
in sap bi we have wad, then why we go for sap 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 object stores?
Explain in detail about type 1?
Which versions are used in the bo dashboard work?
Explain what are the measure objects?
What is thumbnail?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain is there any other repository domains rather than universe, security, document?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
what is xcelsius architecture?
What is difference between custom hierarchy and report based hierarchy?
What are the data types present in bo? What happens if we implement view in the designer and report?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
