Re: Hints used most often?
From: Oxnard Montalvo <oxnard_at_carolina.rr.com>
Date: Tue, 1 Apr 2008 9:42:46 -0400
Message-ID: <30651613.547311207057366207.JavaMail.root@cdptpa-web01-z02>
Date: Tue, 1 Apr 2008 9:42:46 -0400
Message-ID: <30651613.547311207057366207.JavaMail.root@cdptpa-web01-z02>
the hint I use most often .... QB_NAME I use it as much as possible since it helps find a particular query for troubleshooting. (10 and up).
cardinality would be the next. It give the optimizer better information.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 01 2008 - 08:42:46 CDT