Home Forums SQL Server 7,2000 Performance Tuning Need help optimizing a query RE: Need help optimizing a query
Lynn Pettis
SSC Guru
Points: 442467
More actions
April 9, 2013 at 12:37 pm
#1604966
Also, if you are adding and deleting data, you really should create a clustered index on the table. As a heap it will just continue to grow and not reuse empty space allocated to the table.