Discussion in 'SQL PL/SQL' started by Cathydoesloans, Sep 30, 2016.
Hi, I need to help guys, when a full table scan is more favorable access on the index?
I have to search ,i will tell u
It is impossible to tell that the FTS method bad or good.
Everything depends on the task.
If you need to process more than 30% of entries in the table, then it is better to use FTS.
Indexed access can be used for receiving one or several records, for retrieval AND operations etc.
If in case of access to the table across the field or to several fields the index isn't created, then oracle will use FTS/FSI(IOT).
The choice of the data access method is influenced by statistics.
I blogged on that here:
Possibly that post will answer your question.
Thank u so much, I'm gonna check it out.