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

What's the benefit of "dbms_stats" over "analyze"?

by issuing "alter tablespace begin backup;" what happens to tablespace?

What is dcl? : sql server DBA

How do you troubleshoot errors in a sql server agent job? : sql server DBA

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

How would you determine the time zone under which a database was operating?

How do you add a data file to a tablespace?

Hot backup procedure?

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

What are the different ways you can create databases in sql server? : sql server DBA

how will u see whether the dabase is in archive log mode or not?

For more DB Administration Interview Questions Click Here