Tag: Index
9 articles
MySQL Index and Sorting: Filesort and Index Sort
filesort sorting, index sorting, two-pass sorting, single-pass sorting, clustered index and secondary index sorting.
MySQL Index Optimization: Table Lookup, Covering Index, Leftmost Prefix and LIKE
Table lookup queries, covering index, leftmost prefix principle, LIKE queries, NULL value handling.
MySQL Clustered vs Secondary Index: Structure, Principle and Performance Deep Dive
Clustered index (secondary index, primary key index), secondary index, table lookup query, covering index.
MySQL Index Principles: B+Tree, Hash, Binary Search
Index principles: B+Tree, Hash index, binary search, InnoDB adaptive hash index.
MySQL Index Types: BTree, Hash, FULLTEXT, RTree Explained
Index types: BTree, Hash, FULLTEXT, RTree, regular index, unique index, primary key index, composite index, clustered index.
Neo4j Transaction, Index and Constraint Practice: Syntax, Concurrency and Troubleshooting
Neo4j transaction handling, index creation, constraint settings and concurrency issue troubleshooting.
MongoDB Indexing: Types, Principles & Best Practices
MongoDB indexes are core mechanisms for improving query performance, including single field indexes, compound indexes, multi-key indexes, geospatial indexes...
MongoDB Index Management & explain Execution Plan Analysis
MongoDB index management includes createIndex, getIndexes, dropIndex operations.
MongoDB vs MySQL: B-Tree vs B+Tree Index Mechanisms
MongoDB uses B-tree indexes where nodes store both data and keys. MySQL uses B+tree indexes with all data concentrated in leaf nodes.