Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Why does the optimizer ignore the FFS_INDEX hint ???

Why does the optimizer ignore the FFS_INDEX hint ???

From: Roger <rg_at_mcs-hh.de>
Date: Wed, 11 Oct 2000 07:00:58 +0200
Message-ID: <8s0rv5$9v2$1@garnet.hamburg.cityline.net> 






I tried the following



select /*+ INDEX_FFS (artikel artnr) */ count(1) from article group by artnr



The optimizer does a full table scan and a sort operation. Since there is a
index on artnr I don't understand why Oracle doesn't do a fast full scan on
the index and just count the records. I don't see why there is a sort
operation involved, since an index with the rigth sort order can be used.
The other thing I don't understand is that the hint is ignored ?



Regards


   Roger
Received on Wed Oct 11 2000 - 00:00:58 CDT












Original text of this message













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