Re: feature & performance comparison

From: Knut Stolze <stolze_at_us.ibm.com>
Date: 11 Jun 2001 15:47:04 GMT
Message-ID: <slrn9i9pvp.ee2.stolze@stolze.stl.ibm.com>

On Mon, 11 Jun 2001 09:48:58 GMT, Nuno Souto wrote:

> Mind you, I still prefer the CONNECT BY: I don't have to use a
> DISTINCT to get the parts explosion. DISTINCT is not good for
> performance in any database.

You don't have to use distinct, it depends on the data you have in the table and what your recursion should do.

> I wonder what happens if there is more than one root? As in multiple
> parts and their makeup in a single table.

It just works as expected.

-- 
Knut Stolze
DB2 UDB Spatial Extender
IBM Silicon Valley Lab

Received on Mon Jun 11 2001 - 10:47:04 CDT