SQLPerfTips
use-the-index-luke.com
Actively hiring
Books
Information Technology
Database Management
Follow
Overview
News
Technologies
Salaries
Products
People
Growth
Offices
Financials
Overview
SQL indexing and tuning tutorial for developers. No unnecessary database details—just what developers need to know. Covers all major SQL databases.
News
The primary key is the default clustered index in SQL Server and MySQL. This implies a
Unreasonable Defaults: Primary Key as Clustering Key
Read more
Report
3-Minute Quiz: What do you know about SQL performance?
Just 5 questions to see how much you know about SQL performance. Never make these mistakes again.
Read more
Report
Index merge: using multiple indexes for one table access
It is one of the most common questions about database indexing: is it better to have one separate index for each column or a single index for all columns of a WHERE clause?
Read more
Report
OFFSET is bad for skipping previous rows
OFFSET doesn't deliver stable results and makes the query slow. Key-set pagination does neither.
Read more
Report
Index Usage For EXTRACT(YEAR FROM …), YEAR(…) etc.
Automatic Rewrite of Date and Time RangesThe following chart shows which DBMS rewrites where clause expressions that access the year part of a date or timestamp (or the like) into a range expression such as ts = DATE'2024-01-01' AND ts DATE'2025-01-01'. T
Read more
Report
Pro access
Upgrade to see all 16 mentions
Upgrade to a paid plan to read every media mention of this company - funding news, awards, product launches and press releases from all the outlets writing about it.
Every media mention and press release
Funding news, awards and product launches
Fresh coverage from every outlet writing about the company
Upgrade now
Cancel anytime. Secure checkout. Instant activation.