Index is used to Retrive the Information in efficient manner. And query pr

What is an index and types of indexes. How many number of
indexes can be used per table ?

Question Posted / rm thirunavukkarasu

12 Answers
83380 Views
Accenture, BirlaSoft, Cognizant, CTS, Symphony, I also Faced
E-Mail Answers

Answer Posted / rm thirunavukkarasu

Index is used to Retrive the Information in efficient
manner. And query processor perform reliably.

There are 3 types of Index namely
*Cluster based Index
*Non Cluster based Index
*Noncomposite Index
*Compositive Index
*Unique Index

For more info adt sql plz visit www.thiruna.blog.com

Is This Answer Correct ?

8 Yes

16 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

960

Can a view be mutating? If yes, then how?

963

What do you know by pl/sql cursors?

1037

What is a trigger in sql?

1158

What is autocommit sql?

925

what are myisam tables? : Sql dba

955

Explain character-manipulation functions?

1070

Does inner join remove duplicates?

888

What is a loop in sql?

937

Is sql microsoft?

977

Why are aggregate functions called so?

896

How many indexes can be created on a table in sql?

989

what are null values? : Sql dba

902

what is a database transaction? : Sql dba

1108

What is delete command in sql?

1053