Oracle PL/SQL: INDEXES: Rebuild Reverse - REVERSE stores the bytes of the index block in reverse order and excludes the rowid when the index i

Quick Search:

Oracle PL/SQL: INDEXES: Rebuild Reverse

Jump to:

Category: >> Oracle PL/SQL >> INDEXES: Rebuild Reverse

<< last

next >>

Snippet Name: INDEXES: Rebuild Reverse

Description: REVERSE stores the bytes of the index block in reverse order and excludes the rowid when the index is rebuilt.

Restrictionss:
Reverse indexes are subject to the following restrictions:

- You cannot reverse a bitmap index or an index-organized table.

- You cannot specify REVERSE or NOREVERSE for a partition or subpartition.

Also see:
» INDEXES: View table indexes
» INDEXES: Analyze Index
» INDEXES: Block Dump
» INDEXES:
» INDEXES: ENABLE (function-based index)
» INDEXES: DISABLE (function-based index)
» INDEXES: Alter Index Parallel
» INDEXES: Alter Index Deallocate Unused
» INDEXES: Alter Index Allocate Extent
» INDEXES: Virtual / NoSegment
» INDEXES: Reverse Key Indexes
» INDEXES: Bitmap Join Indexes
» INDEXES: Bitmap Indexes
» INDEXES: Unique indexes
» INDEXES: Parallel Index
» INDEXES: Compute Statistics
» INDEXES: SORT and NOSORT
» INDEXES: Function-Based Index
» INDEXES: DROP index
» INDEXES: Alter index
» INDEXES: Single Column Non-unique
» INDEXES: Index Usage Notes
» Compressed Indexes
» Create INDEX

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 11th, 2009

-- syntax: 
ALTER INDEX <index_name> REBUILD REVERSE;
 
 
-- this example rebuilds idx_sales_region so that the bytes 
-- of the index block are stored in reverse order:
 
CREATE INDEX idx_sales_region
ON index_demo (person_id);
 
SELECT index_name, index_type
FROM user_indexes;
 
ALTER INDEX idx_sales_region REBUILD REVERSE;
 
SELECT index_name, index_type
FROM user_indexes;