Full Table Scan (FTS) in Oracle
A full table scan reads all rows from a table, and then filters out those rows that do not meet the selection criteria. Just because during accessing large number of blocks with FTS Oracle can use multiblock I/O read call, FTS is sometimes better than index range scans. Reason Explanation No index exists. If no … Read more