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 degradation ALL_TYPE_ATTRS select

Re: performance degradation ALL_TYPE_ATTRS select

From: Leon <lrzhemov_at_SHAW.CA>
Date: 8 May 2002 22:58:24 -0700
Message-ID: <58eca64.0205082158.27689cd7@posting.google.com> 





Oracle 8.1.6.0 Standard edition on Linux RedHat 2.2



As soon as this query does not return any records I think I can fool
Oracle and replace ALL_TYPE_ATTRS  with empty local table.



It may work just nicely and execution plan would produce immediate
results after analyzing.



Leon



jimmyn1_at_aol.com (JimmyN1) wrote in message news:<20020508203446.02926.00010702_at_mb-ba.aol.com>...


> What version of the DB are you using?

Received on Thu May 09 2002 - 00:58:24 CDT












Original text of this message













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