Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hint --/*+ INDEX_FFS */-- ignored

568333Apr 10 2007 — edited Apr 10 2007
Hi,
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2007
Added on Apr 10 2007
6 comments
4,893 views