AFAIK there are three major structure types used for storing Oracle index data: B-tree, R-tree and Bitmap. All indexes use one of these structures. However, not sure about CONTEXT, CTXCAT and CTXRULE Oracle text indexes…
What structure is used for storing CONTEXT, CTXCAT and CTXRULE Oracle text indexes
indexoracle
Related Question
- Mysql – How to index for multiple inequality WHERE search conditions
- Oracle Text CTXCAT Domain Index, Transactional, and Before Insert/Update Trigger
- Oracle index on column with length > maximum varchar2 length
- Postgresql – Postgres function index doesn’t work correctly with regular expressions
- Sql-server – Do all Relational DBMSes store table tuples in a clustered index based on primary key by default
- Postgresql – How to make Postgres Multi-Column and Multi-Table Search More Efficient
- Oracle DISTINCT with NULLable columns
Best Answer
The documentation covers this thoroughly.
See this link for more detail.