Sometimes a poor clustering factor is the cause when Oracle Database cost based optimizer does not choose to use an index. Oracle 12c (12.1.0.2 EE) offers a new feature that can really help – “Atrribute Clustering”. This is implemented with a new keyword on CREATE TABLE – “CLUSTERING BY LINEAR ORDER”.
In this Free Tutorial from SkillBuilders and Oracle Certified Master DBA John Watson, you’ll get a brief refresher on clustering factor and a demonstration of CREATE TABLE – “CLUSTERING BY LINEAR ORDER” – so the CBO will use your index!
Course Features
- Lectures 5
- Quiz 0
- Duration 12 minutes
- Skill level All levels
- Language English
- Students 6
- Assessments Yes
