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...

Give the reasoning behind using an index.

Answer Posted / rajesh naidu

INDEX IS USED TO IMPROVE THE PERFORMANCE OF THE DATABASE AND
ALSO IT IS USE FULL FOR FASTER FETCHING THE REQUIRED DATA

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1996


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2249


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2605


What is transparent data encryption? : sql server DBA

1251


internal architecture

2250


How can you control the amount of free space in your index pages? : sql server DBA

1373


What are the steps you will take to improve performance of a poor performing query?

2897


how can you initialize log miner?

1186


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1362


What is a correlated sub-query? : sql server DBA

1155


how can you connect from 10g user to 11g user??

2164


I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2150


what are the types of connection load-balancing?

1044


how can you schedule a job in database?

1192


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

2042