Re: Forcing an account to use rule-based optimization

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 18 Aug 1999 18:43:03 +0800
Message-ID: <37BA8E37.7CF7@yahoo.com>

mike.lacy_at_alcoa.com wrote:
>
> 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.

You could always move to 8.1 and setup a logon trigger to set the optimizer mode ...
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Aug 18 1999 - 05:43:03 CDT