Hi,
I have one doubts in using the Distinct keyword to suppress the duplicates from the performance point of view. Why we should not use the Distinct Keyword in the Select statement. To suppress the duplicate, which one is the best to use to avoid the duplication.
while using the Distinct keyword in select clause, I am getting an Performance problem.
If any body knows, please let me know.
Thanks in advance.
Thanks,
Saravanan.P