Gaja
Wrote in his Book 101 Performance Tuning
"When
Running an SQL Query Avoid using Indexes when an index scan performs More Block
Visitations Than a Full Table Scan"
Qs.
How is the Number of Block Visitations to be Found for Both the Index Scan &
Full Table Scan ?