Re: Request in 9i slower than in 8i ...

From: zeb <spam_at_nowhere.com>
Date: Thu, 20 May 2004 11:17:33 +0200
Message-ID: <40ac766f$0$14068$626a14ce@news.free.fr>

> Oracle 9 automatically unnests subqueries
> whenever it is legal to do so. This is why you
> see the hash semi-join in the second plan.
>
> To stop this happening for a specific query,
> you can put in the NO_UNNEST hint into
> the subquery.
>
> Oracle 10g will cost both options are select
> the cheaper.
>

OK, thanks a lot
is there a way to do this at the instance level ( spfile ) ? Received on Thu May 20 2004 - 04:17:33 CDT

This message: [ Message body ]
Next message: Jon: "PL/SQL privileges"
Previous message: Jeremy: "Re: Oracle Text - alternatives?"
In reply to: Jonathan Lewis: "Re: Request in 9i slower than in 8i ..."
Next in thread: Jonathan Lewis: "Re: Request in 9i slower than in 8i ..."
Reply: Jonathan Lewis: "Re: Request in 9i slower than in 8i ..."
Reply: Jonathan Lewis: "Re: Request in 9i slower than in 8i ..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US