Technical Blog
Pages
(Move to ...)
Home
Oracle DBA
ERP
Oracle Apps
Data Warehouse
Java
UNIX
Hadoop
JOBS4U
▼
Showing posts with label
FULL SCAN
.
Show all posts
Showing posts with label
FULL SCAN
.
Show all posts
Jul 14, 2011
UNDERSTANDING EXPLAIN PLAN 5
›
Table Access Options FULL Reads every row in the table. Every block is read until the high water mark of the table is ...
Jun 29, 2011
UNDERSTANDING EXPLAIN PLAN 1
›
UNIQUE Sorts to eliminate duplicate rows. This typically occurs as a result of using the DISTINCT clause. SORT UNI...
›
Home
View web version