[thelist] SQL Book Online

Jon Haworth jhaworth at witanjardine.co.uk
Thu Mar 6 11:07:00 CST 2003

Hi Josh,

> Does anyone know of an in depth tutorial that
> explains HOW different SQL queries are interpreted
> by the SQL parser e.g. how the computer thinks?

I don't know of a tutorial, I'm afraid, but I have a suggestion that works
well for me (assuming you're on Windows): If you download MSDE or the demo
of SQL Server, you can install Enterprise Manager, which comes with a
*really* good Query Analyser.

Paste your SQL into Query Analyser, and select "Show Execution Plan" under
the "Query" menu - you'll get a very clear graphical representation of
exactly how the DBMS will interpret your query (and often hints on how to
speed it up).


More information about the thelist mailing list