can anyone help me ? an index has been done on the primary key of a table. an u

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

Question Posted / kavi

2 Answers
5623 Views
iFlex, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

can anyone help me ? an index has been done on the primary key of a table. an update operation was ..

Answer / 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

can anyone help me ? an index has been done on the primary key of a table. an update operation was ..

Answer / 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

More Business Objects Interview Questions

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

3 Answers iFlex,

What is maximum number of promts we can give in a BO report?

1 Answers Patni,

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

0 Answers

what r the advantages of creating the universe?

2 Answers

What are the diffrences between Business Objects 5.1 & 6.5 ?

1 Answers Siemens,

HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

2 Answers Polaris,

Can anyone plz tell me How to create universe in business objects enterprise 11.5

3 Answers

what is variable ?

3 Answers Tech Mahindra,

How do u get requirement from the client? in what format?

1 Answers TCS, Wipro,

What is aggregate table and aggregate fact table ... Any examples of both?

0 Answers

Is it possible to generate reports without having knowledge of the Universe structure?

4 Answers

how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?

1 Answers Accenture, TCS,

For more Business Objects Interview Questions Click Here