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 on queries with a lot of AND / OR operators

Re: Performance on queries with a lot of AND / OR operators

From: Daniel Fink <danielwfink_at_yahoo.com>
Date: 19 Aug 2005 06:16:39 -0700
Message-ID: <1124457399.034400.4750@g47g2000cwa.googlegroups.com> 





Excellent point!



>From my experience, code generators kill the shared_pool by

1) not using bind variables


2) creating monster WHERE clauses



The end result - you can't reuse *any* of the code generated sql.



Dan
Received on Fri Aug 19 2005 - 08:16:39 CDT












Original text of this message













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