Give the reasoning behind using an index.

Question Posted / guest

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

More DB Administration Interview Questions

Where in the Oracle directory tree structure are audit traces placed?

what is a crs resource?

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

Compare and contrast TRUNCATE and DELETE for a table.

What would you use to improve performance on an insert statement that places millions of rows into that table?

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

who owns the operating system files created by the utl_file package?

Explain the use of table functions.

What are the different types of upgrades that can be performed in sql server? : sql server DBA

Datapump backup steps?

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1)how to Take Backup in sql server 2005 from Flash Drive

For more DB Administration Interview Questions Click Here