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
83824 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

How do I remove sql developer from windows 10?

1101

What is update query?

973

What is equi join in sql?

1066

Is sql harder than python?

1094

What is dml and ddl?

948

difference between anonymous blocks and sub-programs.

1130

What is sqlca in powerbuilder?

1000

How do I edit a trigger in sql developer?

990

Write a sql query to convert all character to uppercase after hypen.

1433

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1121

What is information schema in sql?

1067

How do you declare a user-defined exception?

1022

Compare sql & pl/sql

1128

What is trigger types in sql?

989

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1057