Databases Reference
In-Depth Information
Figure 11.2
Oracle Explain for a query execution plan. (Image courtesy of Oracle Corp.)
EXPLAIN PLAN SET statement_id = 'Oracle-example1' FOR
SELECT arrival_date, name, description, inventory_id
FROM product_stock
WHERE arrival_date = :b1
AND name LIKE '%-COM'
AND NVL(end_date_active,sysdate+1) > SYSDATE ;
Plan
--------------------------------------------------
SELECT STATEMENT
TABLE ACCESS BY INDEX ROWID PRODUCT_STOCK
INDEX RANGE SCAN STOCK_ITEMS
