When using the sysindexes for information use the dbcc updateusage with count_rows before the query.

The information in sysindexes can be way off. It happened to me. Tables filled with...