|Oracle uses indexes to speed upt searches.|
This article will try to explain some concepts around indexes.
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.|
SVN diff examples
|What did I change since the last commit?|
What was changed in the last commit? A little example on the linux Command Line
Bind variables in MariaDB
|In this article I demonstrated the use of bind-variables in Oracle.|
We can also do that in MariaDB/MySql.
Date/time format in rman
|The default date formatting within RMAN is, my eyes, not very helpfull. |
Luckily there is a very easy way around this (minor) inconvenience.
Bind variables in sqlplus
|Is it possible to work with bind-variables in SqlPlus...yes ofcourse it is.|
Here a little howto!
The bash case statement
|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.
|As a reminder to myself....|
Where to find how a oracle "internal" view is build.