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 we need to discuss with designer before starting the universe designing.
What Is Snow Flake Schema?
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
What are the data types present in bo? What happens if we implement view in the designer and report?
How to open a universe with out using the Designer ??
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What is top business?
what is document design in boxi,have u participate in that
Explain which versions are used in the bo dashboard work?
How were the reports scheduled and how to resolve unexecuted documents?
How we drill up week to month?
What is thumbnail?