I am learning the most difficult part of performance tuning.
Almost all of our sql statement use bind values. With binding
variables in your sql statement, oracle does not allow you to explain
plan, should i just change the sql, hard code it and explain it and
believe that oracle will use the same execution path as the binding one?
How about histograms?
Thanks for you help.
--
Sent by dbadba62 from hotmail subpart of com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new
========= WAS CANCELLED BY =======:
From: u518615722_at_spawnkill.ip-mobilphone.net (Mike F)
Control: cancel <l.1011976519.1981536865@[64.94.198.252]>
Subject: cmsg cancel <l.1011976519.1981536865@[64.94.198.252]>
Date: Sun, 27 Jan 2002 23:22:16 GMT
Message-ID: <cancel.l.1011976519.1981536865@[64.94.198.252]>
X-No-Archive: yes
Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.misc
NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88
Lines: 1
Path: news.uni-stuttgart.de!fu-berlin.de!news.mailgate.org!news2.euro.net!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp03!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40716328
This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.
Received on Fri Jan 25 2002 - 10:35:18 CST
