Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance problem in a "Connect-By" query over a DAG-edges table

Re: Performance problem in a "Connect-By" query over a DAG-edges table

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Tue, 13 May 2003 09:34:24 -0700
Message-ID: <Ce9wa.5$Hl.36@news.oracle.com>


"Oren Louidor" <olouidor_at_tx.technion.ac.il> wrote in message news:39d6c4dc.0305130134.22e9652_at_posting.google.com...
> Maybe righting distinct at the select statement will help? This is the
> thing we will test next.

AFAIK, there is no optimization of distinct on the top of connect-by query. That said, there is little you can do:-( I would be very interested to know if you found some trick. Received on Tue May 13 2003 - 11:34:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US