Analyze table ... delete statistics;
regards
Jo
Hussain Ahmed Qadri <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/16/2003 08:54
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Undo Analyze Table
You might try playing with different values for
optimizer_index_cost_adj.
If this is still at the default of 100, it may be allowing the
optimizer to consider the index more expensive than it should.
You can change this parameter at the session level, but may consider
testing to lower it system wid
The answer is found in the Jonathan Lewis book "Building Efficient Databases".
You should set OPTIMIZER_INDEX_COST_ADJ and OPTIMIZER_INDEX_CACHING.
Explanation:
It is realistic to expect a part of an index to be cached and it is also
realistic to expect the index access to be somewhat cheaper the
Title: RE: Undo Analyze Table
Thank you all,
I'll test and see what helps,
Regards,
Hussain
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 16, 2003 5:37 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Undo Analyze Table
The a
There's a good document about this two interesting parameters:
http://www.evdbt.com/SearchIntelligenceCBO.doc
and also see "asktom"
http://asktom.oracle.com/pls/ask/f?p=4950:8:308736813964790489::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:6601251003901,
=== At 2003-06-16, 04:37:00 you wrote