SQL Performance Articles

Page 1 of 1 (3 articles)

12/10/2024 • EN

Index Usage For EXTRACT(YEAR FROM …), YEAR(…) etc.

Explains how different database systems rewrite date/time range queries to enable efficient index usage for functions like EXTRACT(YEAR FROM ...).

Database Optimization Date Functions Index Usage Query Rewriting SQL Performance

Markus Winand

9/13/2011 • EN

DBMS_STATS - GATHER AUTO

Explains the ambiguous GATHER AUTO option in Oracle's DBMS_STATS for gathering database statistics, clarifying its behavior compared to STALE and EMPTY.

Database Optimization Dbms Stats oracle SQL Performance Statistics Gathering

Robin Moffatt

3/25/2010 • EN

MySQL: Are you actually utilizing your indexes?

How rewriting a MySQL query to use indexes properly improved performance from 10 seconds to 0.03 seconds.

Execution Plan indexing mysql Query Optimization SQL Performance

Lea Verou

SQL Performance Articles

Index Usage For EXTRACT(YEAR FROM …), YEAR(…) etc.

DBMS_STATS - GATHER AUTO

MySQL: Are you actually utilizing your indexes?

Select Language

We use cookies