I am investigating indexes in SQL 2000 and I was wondering if anyone could point me in the right direction to get an overview of any new performance issues that SQL 2000 has over SQL 7 with reference to table indexes.
Printable View
I am investigating indexes in SQL 2000 and I was wondering if anyone could point me in the right direction to get an overview of any new performance issues that SQL 2000 has over SQL 7 with reference to table indexes.
I found this Q & A interesting, it mentioned reverse indexes and full text indexing
http://www.microsoft.com/TechNet/cha...ns/sql0426.asp