MySQL FORCE INDEX Summary: in this tutorial, you will learn how to use the MySQL FORCE INDEX to force the Query Optimizer to use specified named indexes. The query optimizer is a component in the MySQL Database server that makes the most optimal execution plan for an SQL statement. The query optimizer uses the available…
Read more
MySQL USE INDEX Hint Summary: in this tutorial, you will learn how to use the MySQL USE INDEX hint instruct the query optimizer to use only a list of named indexes for a query. Introduction to MySQL USE INDEX hint In MySQL, when you submit an SQL query, the query optimizer will try to make an…
Read more
MySQL Index Cardinality Summary: in this tutorial, you will learn about the MySQL index cardinality and how to view the index cardinality using the SHOW INDEXES command. Index cardinality refers to the uniqueness of values stored in a specified column within an index. MySQL generates the index cardinality based on statistics stored as integers, therefore,…
Read more
MySQL Clustered Index Summary: in this tutorial, you will learn about the MySQL clustered index and how clustered indexes are managed in InnoDB tables. Introduction to the MySQL clustered index Typically, an index is a separate data structure such as B-Tree that stores the key values for faster lookups. A clustered index, on the other…
Read more
MySQL Composite Index Summary: in this example, you will learn about the MySQL composite index and how to use it to speed up your queries. Introduction to MySQL composite index A composite index is an index on multiple columns. MySQL allows you to create a composite index that consists of up to 16 columns. A…
Read more
MySQL Descending Index Summary: in this tutorial, you will learn about MySQL descending index and how to leverage it to increase the performance of queries. Introduction to MySQL descending index A descending index is an index that stores key values in the descending order. Before MySQL 8.0, you can specify the DESC in an index…
Read more
MySQL Invisible Index Summary: in this tutorial, you will learn about MySQL invisible index and the statements to manage index visibility. Introduction to MySQL invisible index The invisible indexes allow you to mark indexes as unavailable for the query optimizer. MySQL maintains the invisible indexes and keeps them up to date when the data in…
Read more
MySQL Prefix Index Summary: in this tutorial, you will learn how to use MySQL prefix index to create indexes for character string columns. Introduction to MySQL Prefix Index When you create a secondary index for a column, MySQL stores the values of the columns in a separate data structure e.g., B-Tree and Hash. In case…
Read more
Using MySQL UNIQUE Index To Prevent Duplicates Summary: in this tutorial, you will learn how to use the MySQL UNIQUE index to prevent duplicate values in one or more columns in a table. Introduction to the MySQL UNIQUE index To enforce the uniqueness value of one or more columns, you often use the PRIMARY KEY…
Read more
MySQL SHOW INDEXES Summary: in this tutorial, you will learn how to query index information from a table by using the MySQL SHOW INDEXES command. Introduction to MySQL SHOW INDEXES command To query the index information of a table, you use the SHOW INDEXES statement as follows: SHOW INDEXES FROM table_name; Code language: SQL (Structured…
Read more