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: UNION CASTING .

Re: UNION CASTING .

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Fri, 27 Apr 2001 22:23:17 +0200
Message-ID: <3AE9D535.B538CD7B@0800-einwahl.de> 






Can you please provide such an example where the optimizer is 100 times faster
by knowing that a column is not nullable? Can you show the query and the
suboptimal execution plan? It seems that is your real problem and you try to
solve it by a very difficult (if not impossible) method.



Or is it 100 times faster because you select from an intermediate result table?



Martin
Received on Fri Apr 27 2001 - 15:23:17 CDT












Original text of this message













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