All, How do I improve the scan density on the table? I run the DBCC SHOWCONTIG and find that the scan density is at 75%. Is fillfactor the only route to improve scan density or is there any other route. Thanks.
Hi ya, if you have a clustered index on the table then dbcc dbreindex will improve scan density, otherwise creating a clustered index and then dropping it will improve the density Scan density often reduces as part of normal table usage (insert/update/delete) fillfactor can guard you against an initial burst of this activity, but is not maintained after the index is created Cheers Twan
And its better to leave default for fillfactor rather experimenting it if you'd performance issues. 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.
A value of 100 means the pages will be full and will take the least amount of storage space. A lower value leaves more empty space on the data pages, which reduces the need to split data pages as indexes grow but requires more storage space. This setting is more appropriate when there will be changes to the data in the table. 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.
not quite, fill factor 100 fills the pages completely, fill factor 0 leaves some space in the non-leaf pages of the index Cheers Twan
