Which is the best way to prove that the index of a table is up to date?
I'm trying with this query:
select substring(name,1,30),substring(moddate,1,30) from sysobjects o, sysstatistics s where o.id *= s.id and name like '%table_name%'
And it gives more than one row with different moddates, which I don't understand. In the beggining I though it was because the table was partitioned, but it isn't.
Why does this happen and how do you check the indexes of the tables?
Thanks in advance.