Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance problem in a "Connect-By" query over a DAG-edges table
"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