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
- 5624 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain when to use local filter and when to use global filter?
Explain difference between zabo and webi?
Can we configure two instances of CMS pointing to two different CMS system databases?
Did you face any problems while creating reports? Name? Solutions?
What are the steps to do to use alerts in bo?
What is the difference between slice and dice and cross tab report?
Explain which versions are used in the bo dashboard work?
Can Bo generates the Report from the cubical data Explain?
Can we Save (save as) WEBI Doc as DESKI?
Difference between b.o 5.1 and 6.1b?
