Give the reasoning behind using an index.

Answers were Sorted based on User's Feedback



Give the reasoning behind using an index...

Answer / mathavan

Indexes are used for faster access of required data in a
large table.

Is This Answer Correct ?    7 Yes 1 No

Give the reasoning behind using an index...

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

More DB Administration Interview Questions

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,


Explain the difference between a data block, an extent and a segment.

2 Answers  


Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,


what do you understand by fine-grained auditing?

1 Answers   Oracle,


What are the different types of indexes available in sql server? : sql server DBA

1 Answers  


What are the commands used in dcl? : sql server DBA

1 Answers  


what is logical system in sap basis

1 Answers  


how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,


Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  


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

1 Answers  


Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  


How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  


Categories