Thanx for reply

actually there are nonclusteed indexes associated with the various coloum of the table.....actually its not Full table scan.........but the indexes are showing abnormal behaviour some times its fast...