Vivien Xing (8/13/2008)
I think answer "Yes" is also right. A simple/straightforward answer."Yes, with full table scan details" is just an answer with more details.
Reindex, of course, a full table scan.
I agree, 'Yes' is still a valid answer, with a little less qualification.
Regards,
Phil