Hai,

Iam Ram. My friend asked me one question, like we have 1 lakh record in a table. how will u write a select statement to optimize it?

I told him that if we have primary key, an ordinary select stmt will be faster.

After seeing this post, Using For XML Auto will be faster than ordinary select stmt. Am i Correct?