non-unique Indexes

• kreskins

  Default port

  Points: 1429

  More actions

  December 8, 2003 at 10:17 am

  #160240

  I am using SQL 6.5 and someone long gone designed my current working database. They did not architect so that Primary Keys could easily be used. So I am trying to implement a couple non-unique indexes on tables. when I create these indexes the index manager will give a size consisting of rows and KB. I get an accurate row count on most of the tables, but one of them will give me a row count of 151064 when i know that there are approx 335000 rows in that particular table. Any idea why other tables will show the correct row count and this particular table will not? Any help is appreciated.

  Thanks For your continued Help.

  
  Thanks For your continued Help.

• December 11, 2003 at 8:00 am

  This was removed by the editor as SPAM

• Gabor Nyul

  SSCrazy Eights

  Points: 9459

  More actions

  December 12, 2003 at 5:33 am

  #485916

  Try to update the row count usage by DBCC UPDATEUSAGE see BOL

  Tell us if that on has solved your problem

  Bye

  Gabor

  
  
  Bye
  Gabor