index is a database object used for increasing the performance. types

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

Question Posted / alekhya

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

Answer Posted / alekhya

index is a database object used for increasing the
performance.

types of indexes:
1)simple index
2)composite index

Unique index
composite unique index
bitmap index
key compression index
function based index
cluster index
non-cluster index
Reverse key index

Is This Answer Correct ?

12 Yes

13 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the different tables present in mysql? : Sql dba

1049

What is a stored procedure in sql with example?

1211

What is compiled query?

1089

What is the difference between pl and sql?

1154

Is sql a case sensitive language?

1010

What is information schema in sql?

1120

Explain the advantages and disadvantages of stored procedure?

1202

What is latest version of sql?

1104

What is the difference between alter trigger and drop trigger statements?

1166

What is cte?

1026

What is a design view?

978

How to place comments in pl/sql?

1219

How do you truncate?

958

What is the main difference between sql and pl/sql?

1150

How do I turn a list into a table?

1016