UK Oracle User Group

Physically Clustering Data for Phenomenal OLTP Performance

« Return to event

Time: 2:45 PM - 3:30 PM

Track: Track 1

As data volumes continue to increase, SQL performance and tuning remain as critical as ever. But it is not all about Explain Plans, using hints and adding indexes.

How you structure your data and how you cluster your information together is vital to getting the best performance from your database - and it is often overlooked. It is an urban myth that you no longer need to consider where your data actually is, if you care about performance that is. With RAC you need to consider not only where it is in storage but which node it is on...

By using Index Organised Tables, Cluster, Partitioning, normal indexes and other tricks, you can not only access your data quicker, you can greatly increase the use of your database's memory.

Presented by

  • Martin Widlake, ORA-600

Attached Documents

PDFPhysically Clustering Data for Phenomenal OLTP Performance

Published: 05.03.2018 - This document is restricted to members