Re: HELP Tuning SQL statements

From: Phil Cook <pncook_at_worldnet.att.net>
Date: 1998/02/14
Message-ID: <6c2slg$31s_at_bgtnsc01.worldnet.att.net>#1/1

There have been problems using the cost-based optimizer ( I'm assuming that you are using cost-based since you mentioned hints). The optimizer can choose different access paths depending on if you are using literals or bind variables. I'm assuming that you have analyzed your tables.

I have been successful using a couple of methods, once we upgraded from 7.3.2 to 7.3.3 and overcame a bug with the optimizer. Other times, we have switched to rule-based and the behavior was more predictable.

Phil Cook
Certified Oracle DBA Received on Sat Feb 14 1998 - 00:00:00 CET

This message: [ Message body ]
Next message: John Griffin: "Re: HELP Tuning SQL statements"
Previous message: Jomarlen: "Re: Two Forms Questions"
In reply to: huynuye_at_statcan.ca: "HELP Tuning SQL statements"
Next in thread: John Griffin: "Re: HELP Tuning SQL statements"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message