Types of indexing used in oracle applications ?andwhen and how we decide to implement indexing to database ?

Interview Candidate
Sep 29th, 2005
2
1650

First
Prev
Next
Last

Showing Answers 1 - 2 of 2 Answers

Ram Veer Singh

Apr 11th, 2006

There are twp type of indexing :-
1. Clustered Indexing
2.Unclustered Indexing

bharaniprasanth
Profile Answers by bharaniprasanth Questions by bharaniprasanth

Mar 11th, 2008

Clustered Index creates index for a single or group of keys as One Index..Nonclustered Indexes are created for indvidual columns...If th etable is real big ..better go for clustered indexes...or else non clustered...