Move table rebuild index
|What happens to the space a table-segment uses when a move is executed. |
Same question for a index rebuild.
Index Skip Scan
|What is an Index Skip Scan and what does it?|
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.
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.|