Presentation Title: Boost Performance by Clustering Data
Speaker: Mr Martin Widlake Oracle ACE Oaktable
Company: ORA600
Co-presenter: 
Presentation abstract: Everyone knows how to design a database. Create a few tables, build some indexes and maybe add on some RI. The database engine will take care of accessing the actual data for you. This will NOT get you the best performance you can obtain.

Very few people consider clustering the data anymore, how it is ordered and stored. Doing so can reap huge gains in select performance and reduced memory use.

This presentation will cover Index Organized Tables, single table Hash Clusters, Partitioning and simply ordering your data to boost select performance.

Presentation begins: 10/12/2014 10:00
Presentation duration: 50
Presentation content level: 3 (1 = indepth, 5 = strategic overview)
Audience experience: Basic Working Knowledge
Audience function: Product Expert
Speaker biography: Martin is an Oracle performance engineer with a history of working on VLDBs and introducing new oracle features to clients , where appropriate. He's mostly retired now, he only does this for fun.
Related topics: Database: Database Features & Options, Database: Performance/Internals
Hall: Ex 3

Top