Hi,
Tables Analyzed recently?
Indexes analyzed recently?
Histograms possibly?
If all else fails hints are there to force a certain execution anyway
(Oracle must have known that the CBO wasn't/isn't perfect) so just use
them.
Jack
C.S.Venkata Subramanian [EMAIL PROTECTED]@fatcity.com on
I have analysed the schema using dbms_utility
--
On Thu, 03 Jan 2002 23:25:18
nlzanen1 wrote:
Hi,
Tables Analyzed recently?
Indexes analyzed recently?
Histograms possibly?
If all else fails hints are there to force a certain execution anyway
(Oracle must have known that the CBO
Hi
What is the query?
What is the explain plan w/o hints?
what is th eexplain plan with hints?
Is it doing hash joins w/o hints (Full table scans) and nested loops with
hints?
Jack
C.S.Venkata Subramanian [EMAIL PROTECTED]@fatcity.com on 04-01-2002
12:35:19
Please respond to [EMAIL
are all your tables/indexes analyzed? if the statistics are not current then
the plans chosen by the CBO can be very bad.
babu
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 12:40 AM
Dear All,
I have been entrusted to
Dear All,
I have been entrusted to tune a web based application. This product is at development
stage. I generated the trace file and found out the indexes on the table. So I
specified hints in all the queries and tested the application. There was a remarkable
increase in performance. Can any