Hotsos Home Page

Document Properties

Title: The Oracle Cost-Based Optimizer in Version 11gR2
Author: Gary Propeck
Get File:
Abstract: The query is submitted to the Oracle Database. After an inordinately long time, the data finally returns. Investigation of the Execution Plan states that the process did a full table scan. Why didn‟t it use the index created to improve the query?
Document type: article
Updated: Thu 19 Jan 2012 (2.7 years ago)
File size: 536,135 bytes
MD5 checksum: d47b7875d964c670ef3610310e69b394
File type: .pdf
Authentication: registered — Registered guest (free registration)