Re: Query on multiple tablespace

From: Isabelle Fernandez <isabelle_at_focus-fr.com>
Date: 1998/12/03
Message-ID: <366667CD.5FB9A6DC@focus-fr.com>#1/1

Hi !

Thanks to everyone I have solved my problem. First I have checked my indexes but everything was ok with that. Then I have look at the explain plan and it uses in a correct way the indexes. The I have applied the solution provided by Mr Burnett (see below) and It WORKS ! Now I am going to explore in details the optimizer options...

Thanks to everyone who helped.

Isabelle.

Stewart Burnett wrote:

> generate some statistics for the tables and switch on the cost based
> optimiser;
>
> ANALYSE TABLE Binaries COMPUTE STATISTICS;
> ANALYSE TABLE Images COMPUTE STATISTICS;
> ALTER SESSION SET OPTIMIZER_GOAL = ALL_ROWS;
>
> and try the query again.
>
> If this works you can either set your whole system to use this optimiser
> goal or compare the explain plan from before and after these changes and use
> a hint to make the optimiser use the correct execution plan.
Received on Thu Dec 03 1998 - 00:00:00 CST