"Use the Index, Luke!" -- https://use-the-index-luke.com ORACLE Couchbase OVERVIEW Index Documentation Index Documentation Types of Indexes: Primary & secondary Index (B-tree) Bitmap Index Partial Index Partitioned Index Function-based index Spatial index Search indexes (full text search) Types of Indexes: Primary & secondary index (lock-free skiplist) Partial index Partitioned index Functional-key index Array index Flex indexes Search index Spatial index Indexing data structures B-Tree Bitmap Spatial Inverted tree Indexing data structures Lock-free skiplist Inverted tree (text) Z-curve (spatial) CLASSES of INDEXES Oracle indexes which can be large and is managed thru bufferpools. Oracle text index can be creed with inmemory option. Couchbase has two classes of indexes: Standard secondary index which can be large and relevant entries are paged in based on usage, memory optimized index , optimized for performance is entirely kept in memory and a wri...
A blog about all things data and data processing issues and interests. SQL, NoSQL, flexible schema, scale-up, scale-out, transactions, high availability.