Answers to the above questions are :-

1) Do you have a clustered index on the table you're looking at? YES, THERE IS A PRIMARY KEYS ATTACHED TO...