Re: Select with lots of JOINS

On 17 May 2006 09:05:52 -0700, "fgabriel.munoz_at_gmail.com" <fgabriel.munoz_at_gmail.com> wrote:

>
>I have a SELECT statement with 70 JOINS and 100 columns in the FROM
>clause. Obviously the SELECT is very slow.
>
>I can't change the data model, so I need a "patch" that can increase de
>speed.

So you are out of luck. There is no such thing as a 'patch' to make things run faster. You'll need to tune and to tune and to tune or
a) denormalize
b) bite the bullet and have the datamodel changed.

--
Sybrand Bakker, Senior Oracle DBA