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: Query rewrite

Re: Query rewrite

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 15 Jul 2005 21:54:19 +0200
Message-ID: <415gd1l15kui8tsqmdiv3dhdntema7g9j2@4ax.com> 





On 15 Jul 2005 11:56:23 -0700, "Ryan S" <rshevchi_at_vt.edu> wrote:



>Yes I did, they are all range scans or unique scans.  I would post the

>plans here if I could.




Please explain why you can't. Apart from your (incorrect) assertion
that a DISTINCT doesn't take time and resources, and removing it is
not going to help, you didn't provide anything to work on, did you?



--
Sybrand Bakker, Senior Oracle DBA


Received on Fri Jul 15 2005 - 14:54:19 CDT












Original text of this message













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