Path: news.easynews.com!easynews!news-out.visi.com!hermes.visi.com!newsfeed.esat.net!diablo.theplanet.net!news.indigo.ie!not-for-mail
Reply-To: "Telemachus" <ihatespam@pleasenospam.org>
From: "Telemachus" <telemachus@ulysseswillreturn.net>
Newsgroups: comp.databases.oracle.server
References: <adn50p$ac7$1@wanadoo.fr>
Subject: Re: CHOOSE & RULE
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <3JFL8.2386$b5.20691@news.indigo.ie>
Date: Thu, 6 Jun 2002 10:13:34 +0100
NNTP-Posting-Host: 194.125.187.82
X-Complaints-To: news@indigo.ie
X-Trace: news.indigo.ie 1023354815 194.125.187.82 (Thu, 06 Jun 2002 10:13:35 BST)
NNTP-Posting-Date: Thu, 06 Jun 2002 10:13:35 BST
Organization: Indigo
Xref: easynews comp.databases.oracle.server:149716
X-Received-Date: Thu, 06 Jun 2002 04:04:26 MST (news.easynews.com)

Much more data needed.  What does explain say for both plans ?
"Oraclion" <oracle@epicentre.fr> wrote in message
news:adn50p$ac7$1@wanadoo.fr...
> Hi
>
> Note: Optimiser is set to CHOOSE
>
> My request is very speed with a RULE hint in the request but if i dont't
use
> the hint it's very very slowly !!!
> Why ?
>
> Thanks
> Oraclion
>
>