Skip to content

Tag: Index

  • MySQL Indexing Internals and Best Practices

    In MySQL

    MySQLIndexPerformance

    Indexes are the decisive factor for MySQL query performance. Understanding InnoDB’s B+Tree index structure is the only way to write SQL that truly hits indexes. B+Tree and the Clustered Index InnoDB organizes indexes with a B+Tree whose non-leaf …

    Indexes are the decisive factor for MySQL query performance. Understanding InnoDB’s B+Tree index structure is the only way to write SQL that truly hits indexes. B+Tree and the Clustered Index InnoDB organizes indexes with a B+Tree whose non-leaf …