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

Give the reasoning behind using an index.

Question Posted / mathavan

Answer Posted / mathavan

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

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Where do you find the default index fill factor and how to change it? : sql server DBA

1085

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

2643

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2521

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2416

How to start SQL Server in minimal configuration mode?

7985

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

1118

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

1212

what is logical system in sap basis

1647

Why does Oracle not permit the use of PCTUSED with indexes?

2947

how can you enable flashback feature?

963

how can you schedule a job in database?

1134

How do you open a cluster administrator? : sql server DBA

1110

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1113

how can you create a user-defined lock?

1024

What are the recovery models for a database? : sql server DBA

1135