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
- 4584 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
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Explain about a task that really tested your analytical abilities?
When we use aggregate awareness function in designer?
Explain the difference between union and group?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Can we create universe with no cache??
What is the difference between the public object&schema object?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What is the functional & architectural differences between business objects and web intelligence reports?
Explain what are the steps to be taken to schedule the report?
Can you please send me the migration related issues .
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
how get the grand total in master-detail 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
explain in detail about type 3?
