Back-end Developer
An index is a data structure that optimizes searching and accessing the data. It’s like an index at the back of a book. Indexing is one of the ways that will optimize your database searching and access is having indexes on the columns that you usually access the table using it. Continue reading “[MySQL] Indexing table”
EXPLAIN is one of the most powerful tools at your understanding and optimizing troublesome MySQL queries. However, many developers rarely make use of it. In this blog post, I would like to share what the output of
EXPLAIN can be and how to use it to optimize your schema and queries.
Continue reading “[MySQL] EXPLAIN the Queries”