Database/Database-Indexing

[giscus[bot]]

Database/Database-Indexing

Database indexing speeds up queries by organizing column values in structures like B-trees, allowing for O(log n) search times versus O(n) full table scans. However, pattern-based searches like LIKE %ZA% require full table scans. Trigram search addresses this by using trigrams (three-character substrings) for efficient matching. Use EXPLAIN ANALYZE to measure query performance and IGNORE INDEX() to disable indexing.

https://notes.yxy.ninja/Database/Database-Indexing

[OliverTeo288]

Good read !

[xy-241]

Thank you, Sir! Let me if you find anything interesting about database indexing :)