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 -> Forcing an account to use rule-based optimization

Forcing an account to use rule-based optimization

From: <mike.lacy_at_alcoa.com>
Date: Mon, 16 Aug 1999 18:04:19 GMT
Message-ID: <7p9jqq$fac$1@nnrp1.deja.com> 





We are running Oracle 7.3.4.x with the cost based optimizer set as the
default.  We purchased an application that works much better if it uses
rule based optimization.  Can I force the application's account to use
rule based?  The connection comes through ODBC and we don't have anyway
to send an "alter session ..." command from the application.  Is there
a login script for a user connecting through ODBC?  Any ideas?



Thanks,


Mike




Sent via Deja.com http://www.deja.com/



Share what you know. Learn what you don't.
Received on Mon Aug 16 1999 - 13:04:19 CDT












Original text of this message













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