Index is a method used for faster retrieval of records.different types of

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

Question Posted / guest

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

Answer Posted / guest

Index is a method used for faster retrieval of
records.different types of indexes are
1.primary key index
2.unique index
3.bitmap index
4.hash index
5.function based index
6.B-tree index(default index created) on table.
7.Virtual index(which do not show entry in DBA_segment).

Is This Answer Correct ?

128 Yes

35 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I start sql profiler?

989

how to use like conditions? : Sql dba

1101

What is pl sql block structure?

1034

What is dbo in sql?

952

Which join is like an inner join?

1021

what are the security recommendations while using mysql? : Sql dba

1111

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

1120

Is sql difficult?

1148

describe mysql connection using mysql binary. : Sql dba

1054

What is file based approach?

934

Does sql between include endpoints?

994

Is json a nosql?

972

How do you declare a constant?

958

What does (*) mean in sql?

945

Can you call pl/sql package functions from within a fast formula?

1033