INDEX

INDEX

There are several types of index available to use in Oracle databases, 

1) B-tree Balanced Tree indexes, -- but most common one is B-tree indexes are more common in databases supporting OLTP systems
2) Function-Based indexes and 
3) Bitmap indexes. -- bitmap indexes are more commonly used for DataWarehouses
 and . B-tree indexes are ordered lists of values divided into ranges with a key associated with a row or range of rows, 
thereby providing excellent retrieval performance for queries such as exact match and range searches.
You can find oracle documentation to know more about B-tree indexes.

SQL> select index_name, status from user_indexes where table_name ='SRI'

Create Index  (CREATE INDEX ONT.OE_ORDER_LINES_ATNT1 ON ONT.OE_ORDER_LINES_ALL

(ACTUAL_SHIPMENT_DATE))

ANALYZE TABLE tablename COMPUTE|ESTIMATE|DELETE STATISTICS ptnOption options

ANALYZE INDEX indexname COMPUTE|ESTIMATE|DELETE STATISTICS ptnOption options

ANALYZE CLUSTER clustername COMPUTE|ESTIMATE|DELETE STATISTICS options

While Analyzing the Index the below error occurred

when table "OE_ORDER_LINES_ALL" is analyzing in PTCH instance. The below error is coming for that table

"ORA-01555: snapshot too old: rollback segment number 24 with name"_SYSSMU24$" too small"