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:

  1. Lesson 1 – Overview of Clustering Factor (1:46) (click on video below)
  2. Lesson 2 – Demonstration – 12c Attribute Clustering (5:12)
  3. Lesson 3 – How to Get Good Clustering (0:57)
  4. Lesson 4 – Where to Use and Restrictions (3:31)

Date: Jul 18, 2016


NOTE: Some corporate firewalls will not allow videos hosted by YouTube.

Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

 

×