[TriLUG] SQL-fu help request

[Alan Porter via TriLUG]

> Yes, it was very good advice and I learned something as a result.  A lot of my
> mistake was in thinking that the order of the limit and order by clauses was
> order agnostic and that the statements would be applied after the query, not
> impact the query.

There is a nice SQL command called "EXPLAIN" that will tell you what the 
database
engine is doing to evaluate your query.  I have not used it myself, but 
I would
like to know more about it.  I bet someone here on this list can give us 
a 50-cent
tour.

Alan