Oracle indexes

An #index is a #schema #object that contains an entry for each value that appears in the indexed #column(s) of the table or #cluster and provides direct, fast access to rows. Oracle Database supports several types of index: Normal indexes. (By default, Oracle Database creates B-tree indexes.)
Indexes are used to search the rows in the oracle table quickly. If the index is not present the select query has to read the whole table and returns the rows. With Index, the #rows can be retrieved quickly

00:00 Oracle Indexes
08:18 Index vs Row ID

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis