When I worked for Sybase, much of the advertising we published was based on the TPC performance benchmark figures of Sybase SQL Server compared to the competition ...
Ok, let's say I have three different queries that all return the same result set.<BR><BR>One uses a temp table, the other a correlated subquery, and the third is just a HUGE set of union queries, etc.