Re: SQL query for foreign keys?

From: Kay Kanekowski <kkanekowski_at_mindcommerce.de>
Date: Wed, 25 Jul 2001 08:27:03 +0200
Message-ID: <9jlta6$5tm$1@fermi.tro.net>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schrieb im Newsbeitrag news:995999735.18431.0.pluto.d4ee154e_at_news.demon.nl...

> Just one small tip for you: the result of a subquery is a set.
> Sets are unique by design. Your distinct is redundant.
> Oracle however is stupid enough to perform 2 distincts on the results on the
> subquery.

Hi,

nice to know. The explain plan and the results are identical with or without distinct. Is this a bug or a feature ;-)

Kay Received on Wed Jul 25 2001 - 01:27:03 CDT