SQL DUEL

// query analyzer 9000 _

[ 01 ] Define the Battlefield

Add your tables, columns, indexes, and rough row counts. The estimator uses this to figure out which query wins.

[ 02 ] Enter Combatants

Drop two SELECT queries. Tabs of variation, SELECT * vs targeted, indexed WHERE vs full-scan WHERE — all fair game.

[ 03 ] Verdict