ILWC What is loading Privacy Statement About ILWC
Registreer
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.
 
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.
 
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.
 
101
SVN diff examples
Martijn
What did I change since the last commit?
What was changed in the last commit? A little example on the linux Command Line
 
100
Bind variables in MariaDB
Martijn
In this article I demonstrated the use of bind-variables in Oracle.
We can also do that in MariaDB/MySql.
 
99
Date/time format in rman
Martijn
The default date formatting within RMAN is, my eyes, not very helpfull.
Luckily there is a very easy way around this (minor) inconvenience.
 
98
Bind variables in sqlplus
Martijn
Is it possible to work with bind-variables in SqlPlus...yes ofcourse it is.
Here a little howto!
 
97
The bash case statement
Martijn
And yet another reminder to myself.
Somehow I also can't seam to memorize the syntax of the case statement in bash.
So here is a little reminder.
 
96
v$fixed_view_definition
Martijn
As a reminder to myself....
Where to find how a oracle "internal" view is build.