Good Indexing : Show CBO where to go

So how can we make this database thing work for us instead of the other way round? This presentation will generally look for the simplest, and the laziest road to to Efficient systems.
Common Joke: The Best way to fix inefficient queries is to not have them.
The next best way is to present them the most efficient path into the data, which is why I will cover some indexing basics items and a few lesser used techniques like IOT and Clusters. The presentation includes some demos which will only be done if time permits.
The 2nd half of the presentation covers basic CBO behavior, some hard-learned lessons and some additional tricks that should only be used in “emergencies”. There are no silver bullets to CBO problems. But it wont hurt to look and learn. As long as we realize that we are using "tricks", and realize our risks and limitations. We might get lucky.

Detalji o predavanju

Vrsta: Predavanje / Lecture

Razina težine: Srednje detaljno / Detailed

Poželjno iskustvo slušatelja: Iskusni (2-3 g.) / Experianced

Poželjna funkcija slušatelja:
Krajnji korisnik / End User
DBA
Sistem Analitičar / System Analist

Predviđeno vrijeme trajanja rada - aktivnosti: 60 min

406_de Visser Indexing & CBO.pdf 1.017,81 kB

O predavaču

Piet de Visser

Logica - Oracle ACE

Piet is an experienced Database Consultant and Administrator, specializing in Oracle databases and High-Availability. He is in IT since 1987, and specializes in Oracle- and Databases-related technology since 1994. He combines technical knowledge with extensive experience in global organizations. His energetic personality and language-skills makes him ideal for pioneering and ground-breaking projects in a multi-national environment. He also invests a lot of effort in maintaining a network of Like-Minded Oracle specialists worldwide and is a regular speaker at international user group events and symposia. Oh, and Piet has a preference for Simple solutions.
Piet de Visser is Oracle ACE.