Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

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

1155


What are all difference between business objects 6.5 and xi r2?

1034


Can Bo generates the Report from the cubical data Explain?

2038


How to restrict password to a user while sending a document in .pdf format

2349


What is the difference between business requirement document and use case document.

1012


What is the functional & architectural differences between business objects and web intelligence reports?

2418


What is the difference between slice and dice and cross tab report?

1056


What is Indexing? how did u implement indexing?

2476


What is the difference between user and versatile user?

1073


Explain about alerts in bos, under what situation we need to use alerts?

1056


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3477


What is difference between custom hierarchy and report based hierarchy?

1020


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

1032


Explain the difference between union and group?

1109


Can anybody tell me what are the tuning problems?

2048