quote:
Jonathan,the paper is about SQL7. I thought the query optimizer hase greatly improved between these versions. Is it still valid for SQL2k?
Frank
They "implemented and experimentally
evaluated [the] approach on Microsoft SQL Server 7.0." The paper was presented more than three years ago. Its authors wrote the MSDN White paper on the SQL Server 2000 Index Tuning Wizard. Draw your own conclusions.
--Jonathan
--Jonathan