• these are the expected stats reason being .when we are calling every records (without any filer/where clause ) definitely Sql optimizer will go for table scan(or i would say clustered index scan ) because every records needs to be pulled out. but when we have any where clause condition or join operation definitely Clus index will give us better results.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)