Re: Starne behaviour of optimizer within in 9i vs 8i

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Mon, 27 Oct 2003 11:56:10 +0100
Message-ID: <r8uppv8aafprh0ec3ij9t9hp9njfa4tefm@4ax.com>

On 27 Oct 2003 02:48:31 -0800, cha_at_christian-hartmann.de (Christian Hartmann) wrote:

>Does anyboy know what the problem might be and maybe know a solution?

who can tell with so little details as to table definition, primary and foreign key definition, index definitions, the type of analysis performed, whether appropiate histograms have been created, etc, etc, etc.

You might want to consider to refrain from posting this type of 'It doesn't work' request completely, as crystall balls have been long sold out here (as you well know, as you are a regular visitor, providing 'puzzles')

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Oct 27 2003 - 04:56:10 CST