Path: news.easynews.com!easynews!newsfeed.frii.net!deine.net!freenix!wanadoo.fr!not-for-mail
From: "Oraclion" <oracle@epicentre.fr>
Newsgroups: comp.databases.oracle.server
Subject: CHOOSE & RULE
Date: Thu, 6 Jun 2002 10:05:23 +0200
Organization: Wanadoo, l'internet avec France Telecom
Lines: 12
Message-ID: <adn50p$ac7$1@wanadoo.fr>
Reply-To: "Oraclion" <oracle@epicentre.fr>
NNTP-Posting-Host: aannecy-201-2-1-6.abo.wanadoo.fr
X-Trace: wanadoo.fr 1023350617 10631 80.11.162.6 (6 Jun 2002 08:03:37 GMT)
X-Complaints-To: abuse@wanadoo.fr
NNTP-Posting-Date: 6 Jun 2002 08:03:37 GMT
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
Xref: easynews comp.databases.oracle.server:149705
X-Received-Date: Thu, 06 Jun 2002 03:07:24 MST (news.easynews.com)

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