>> I can't help wi****ng that the optimizer could figure it out. But that's
probably way down on the list of things an optimizer should be able to do.
<<
Actually, it is not too hard to detect in many cases. If the result
set has a key in it without a cross join, then the rows are UNIQUE.
Perfect ha****ng and bit vector indexing can also spot and reject
redundant duplicates during processing.
