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

Can you have a foreign key without a primary key?

963

How does a trigger work?

1081

What is data type in database?

1004

What view means?

990

Why trigger is used in sql?

984

What is view? Can we update view

1453

What is procedure and function?

1001

What is spool?

1062

What is rank dense_rank and partition in sql?

1050

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

1119

What is pl sql in oracle?

1053

Which is faster view or stored procedure?

952

How is a PL/SQL code compiled?

1244

What is the difference between inner join and outer join?

1002

What is acid property in a database?

1041