Weird Behavior

• JPG

  Old Hand

  Points: 346

  More actions

  September 29, 2005 at 9:07 am

  #89176

  I have a table with 10 Million Rows and one Clustered Index -  on CID Column. 

  I do a DBCC SHOWCONTIG on it and the Scan Density is 16%.  I want to recommend doing a DBCC DBREINDEX on that table, and I wanted to show improvement in query performance.

   

  So I did a "SELECT * FROM <Table1> WHERE CID = 12345".  I got the result back in less than 0.01 seconds with 16% Scan Density.  This surprised me, because I thot there would be some lag and will improve to something better after doing a DBCC DBREINDEX.  But if the damn query returns the result set so quickly, what should be my point of argument to convince that -- "Hey we need to do a DBCC DBREINDEX"

   

   

   

   

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 29, 2005 at 9:10 am

  #594068

  1 row won't take "much" longer. Try fetching 1k rows in a join or a range search then rerun after the reindex, then you should be better off.