Index Full Scan / Index Full Scan Descending
|When will Oracle consider a Index Full Scan or it's sibling Index Full Scan Descending|
Index Unique Scan
|When will the operation Index Unique Scan appear in a explain plan, and what does it actually mean.|
|Oracle uses indexes to speed upt searches.|
This article will try to explain some concepts around indexes.
|What is a rowid? |
What does it look like?
How can Oracle use it?
Full Table Scan
|Full Table Scan. The simplest/basic access operation to retreive data for Oracle.|
|In this article I will do very short demonstration of basic explain plan functionality.|
If there's one thing you should remember : Oracle reads blocks. The smallest part of information Oracle reads (or writes) is a block.
Oracle CBO : Cost Based Optimizer
|This article will only be a index to other articles concerning the Oracle Cost Based Optimizer. Together they try to give some sort of overview about the CBO and what excecution-paths it may choose.|
Creating the data used in the examples
|This short article shows how the data is created for the various examples from the series about the Oracle CBO : Cost Based Optimizer.|
ILWC : whats that
|What is ILWC.nl|
And....who does it.