Hint --/*+ INDEX_FFS */-- ignored
568333Apr 10 2007 — edited Apr 10 2007Hi,
I´m trying to do the test:
-- Create Table
create table a (a number, b number not null, c number);
-- Insert data
Execute 5 times the insert:
insert into a values (1, 2 ,3);
commit;
-- Create Index
create index i_b on a (b);
-- Analyze Table
analyze table a compute statistics
-- Query Table with Hints
select /*+ ALL_ROWS */ /*+ index_ffs (i_b) */ * from a where b = 2
The Explain Plan is:
Operation---------------------------------------------Optimizer-----------------Cost
-------------------------------------------------------------------------------------------------
SELECT STATEMENT---------------------------HINT: ALL_ROWS-----2
TABLE ACCESS(BY INDEX ROWID) A---ANALYZED---------------2
INDEX(RANGE SCAN) I_B----------------------ANALYZED--------------1
My question:
Why Oracle is using Range Scan if I am forcing FFS (Fast Full Scan)?
Thanks in advance,
Paulo Almeida
Sao Paulo/SP - Brazil