Why Won't Oracle Use My Index - 12c Attribute Clustering

267 Views

Thanks! Share it with your friends!

You disliked this video. Thanks for the feedback!

Published Aug 16, 2016

Sometimes a poor clustering factor is the cause when Oracle Database cost based optimizer does not choose to use an index. With 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!

In this first lesson, John will provide a brief review of clustering factor. See all 6 lessons - FREE - at http://www.skillbuilders.com/12c-attribute-clustering

Category: Success

Be the first to comment

Sign in

Create your account

Add Video

Why Won't Oracle Use My Index - 12c Attribute Clustering - Lesson 1

Up Next