Performance Schema Archives - SQL Authority with Pinal Dave

May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Catching Non-SARGable Queries in Action

April 23, 2025

Pinal Dave

SQL Performance

Clustered Index, Execution Plan, Performance Schema, SQL Index

If you ever wondered why a query that looks harmless is performing poorly despite having indexes in place, the answer could non-SARGable queries.

MySQL – Identifying and Optimizing the Busiest Tables

August 1, 2023

Pinal Dave

SQL Performance

MySQL, Performance Schema, Schema

Let us learn Identifying and Optimizing the Busiest Tables in MySQL. MySQL provides an easy way to identify the busiest tables using the performance_schema.