Select DISTINCT to be avoided?

Select DISTINCT to be avoided?

Here’s one take on the matter:

http://www.toadworld.com/KNOWLEDGE/KnowledgeXpertforOracle/tabid/648/TopicID/TSQ4
19/Default.aspx
image001.jpeg