Re: How to force the use of an index ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 7 Oct 1999 11:21:01 +0100
Message-ID: <939291787.19621.0.nnrp-04.9e984b29@news.demon.co.uk>

Is CODE_MATERIEL declared as a non-null column ? If not, the optimiser has to ignore the hint.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Jean-Daniel TOULY wrote in message <7thqqc$mjr$1_at_wanadoo.fr>...
>
>select /*+ INDEX(MATERIEL MATRIEL_FK19)*/ * from MATERIEL order by
>CODE_MATERIEL
>
>but the explain plan results in :
>
> 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=1047 Card=20953
Bytes=5950652)
> 1 0 SORT (ORDER BY)
> 2 1 TABLE ACCESS (FULL) OF 'MATERIEL' (Cost=138 Card=20953
Bytes=5950652)
>
Received on Thu Oct 07 1999 - 05:21:01 CDT