Category: query optimization
-
Beyond creating indexes – Part 3B
One factor that contributes to query execution time is the number of rows involved. Now, does all of the data on our hottest tables really needs to be there? Is there an escalable and secure way to move stale/invalid rows out of the way? That’s what today’s post is all about.
-
Beyond creating indexes – Part 3A
One factor that contributes to query execution time is the number of rows involved. Now, does all of the data on our hottest tables really needs to be there? Is there an escalable and secure way to move stale/invalid rows out of the way? That’s what today’s post is all about.
-
Beyond creating indexes – Part 2
In this post we are going to focus on views/CTEs/subqueries in the FROM. We will discuss how the database server deals with them and how they can be optimized
-
Beyond creating indexes – Part 1B
Second part of a blog about optimizing queries involving low cardinality columns
-
Beyond creating indexes – Part 1A
Part I of a blog series exploring what else can be done aside from creating an index when optimizing MySQL queries