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

Описание: 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-attr...