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
83359 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 is a behavioral trigger?

930

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1158

how to get help information from the server? : Sql dba

874

Can we insert data into materialized view?

896

what is the command line end user interface - mysql? : Sql dba

925

what is sub-query? : Transact sql

1039

What is a schema? How is it useful in sql servers?

1042

Describe sql comments?

959

Can we insert data in view?

888

Is inner join same as self join?

1060

What is PL/SQL Records?

1114

What is left join in postgresql?

995

What are sql objects?

1012

What is pivot table in sql?

1017

How do I order columns in sql?

912