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).
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!