SQL Tuning : TABLE FULL SCAN / WITH INDEXES

• Full Scan I/O is cheaper than I/O

95% of disk latency is the time required for the read-write head to move itself under the proper cylinder

• Blevel
• number of level in a b-tree index, common size 3 but can be 4 in data warehouse
• column on dba_indexes