>Suhas,
>The indexes of this table has something in the filter clause?
>Something like: Index On MyField... Filter Not Deleted()

there are no deleted records