Hi:

I have a table with unique index built. When I do a select count(*) on this table, it always goes through a full table scan.

I have verified that the table is valid. Can some one give me some ideas as to where the problem would be.

Looks like this is true on all the tables I have created so far.

I am running Oracle EE 8.1.6.

Thanks for your help in advance.

Giri