[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).

Cheers
Jon



More information about the thelist mailing list