ILWC What is loading Privacy Statement About ILWC
Registreer
121
Anti Join
Martijn
What is a Anti Join and how is it used.
 
113
Index Skip Scan
Martijn
What is an Index Skip Scan and what does it?
 
110
Index Full Scan / Index Full Scan Descending
Martijn
When will Oracle consider a Index Full Scan or it's sibling Index Full Scan Descending
 
109
Index Unique Scan
Martijn
When will the operation Index Unique Scan appear in a explain plan, and what does it actually mean.
 
107
Indexes
Martijn
Oracle uses indexes to speed upt searches.
This article will try to explain some concepts around indexes.
 
106
Full Table Scan
Martijn
Full Table Scan. The simplest/basic access operation to retreive data for Oracle.
 
105
Explain Plans
Martijn
In this article I will do very short demonstration of basic explain plan functionality.
 
104
Blocks
Martijn
Blocks

If there's one thing you should remember : Oracle reads blocks. The smallest part of information Oracle reads (or writes) is a block.
 
103
Creating the data used in the examples
Martijn
This short article shows how the data is created for the various examples from the series about the Oracle CBO : Cost Based Optimizer.
 
102
Oracle CBO : Cost Based Optimizer
Martijn
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.