Why Won’t Oracle Use My Index – 12c Attribute Clustering
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!
This free Oracle 12c training is segmented into several separate lessons:
- Lesson 1 – Overview of Clustering Factor (1:46)
- Lesson 2 – Demonstration – 12c Attribute Clustering (5:12)
- Lesson 3 – How to Get Good Clustering (0:57) (click on video below)
- Lesson 4 – Where to Use and Restrictions (3:31)
Date: Jul 18, 2016
NOTE: Some corporate firewalls will not allow videos hosted by YouTube.