Re: Please Help: Sudden Drop in SQL Performance

From: Harald Wakonig <wakonig_at_compuserve.com>
Date: Sun, 09 Jan 2000 23:01:19 +0100
Message-ID: <3879052E.6631ADAC@compuserve.com>

Hi Jack,

> 3) Check if any of your tables/indexes have statistics. This will cause
> weird performance - even in rule based....if they are there Oracle uses
> them!

Oracle uses statistics even if rule based ? I understand that behaviour if optimizer mode = choose - that is documented, but if optimizer mode = RULE ????

Is this

(1) just a rumor
(2)  a documented feature (where ? which Oracle-manual ?)
(3)  a bug - (Bug-Nr. please) - generic or platform / release-specific ?

Thanks,

Harald Received on Sun Jan 09 2000 - 16:01:19 CST