SQL 6.5 table response time | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL 6.5 table response time

Hi guys<br />I have a little problem here, i have a table that has it’s scan density at 58% and i ran dbcc dbreindex and the table is still 58%(fragmented). Now i don’t know how to increase the scan density so as to defragment the table because users are complaining of slow response time. Any ideas of what i can other things i need to check or how i can further optimise the table much appreciate. <br />’SQL 6.5 is just a pain can’t find much support out there’ [<img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ />]
What is the fillfactor on the index?
How often you perform UPDATE STATISTICS & SP_RECOMPILE on this database? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>