Why Won’t Oracle Use My Index – 12c Attribute Clustering
Duration: 50 hours
If you are a student of an accredited academic institution call us for a 25% discount.
Sometimes a poor clustering factor is the cause when Oracle Database cost based optimizer does not choose to use an index. Oracle 12c (18.104.22.168 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!