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
- 5431 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...
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,
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
How to open a universe with out using the Designer ??
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
How would you format some text using css to be verdana and bold?
What are the data types present in bo? What happens if we implement view in the designer and report?
What are the steps to be taken to schedule the report?
Explain about a task that really tested your analytical abilities?
How to restrict password to a user while sending a document in .pdf format
Explain is there any other repository domains rather than universe, security, document?
Which versions are used in the bo dashboard work?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
