When using a count(distinct) is it better to use a self-join or temp table to find redundant data, and provide an example?

Questions by hindol_saha   answers by hindol_saha

Showing Answers 1 - 2 of 2 Answers

manish.baehal

  • Apr 5th, 2009
 

COUNT(Distinct) is better than using Self Join to find redundant data as it is faster and shorter. Beside this COUNT(Distinct) provide more flexibility.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions