The 3-Minute Test: What do you know about SQL performance?


“SQL-Tuning is black magic 
like alchemy:
It consists of obscure rules,
understood by a handful
of insiders only.”

That is a Myth. SQL databases use well-known algorithms to deliver predictable performance. It is, however, easy to write SQL queries that cannot use the most efficient algorithm, thus delivering unexpected performance.

The following questions show examples that make you believe SQL tuning is black magic. But the explanations at the end need just a few sentences to turn the black magic into science.

Choose your Database

MySQL Oracle PostgreSQL SQL Server  

Recent Questions at Ask.Use-The-Index-Luke.com

0
votes
1
answer
229
views

query regd the CBO decision

Apr 17 at 10:27 Hulda(suspended)
index-choice optimizer
0
votes
3
answers
2.0k
views

Examples for Function Based Indexes?

Mar 25 at 15:52 Castorp 1
function-based
0
votes
1
answer
610
views

Updating multiple rows using a subquery in SQL

Jan 08 at 09:52 Jan 26
subquery update sql