The Forgotten Performance Tuning Trick - Clustering your Data

Track

DBA

Date and time

Thursday, 20. October 2016., 09:55

Room

Hall B

Duration

45'

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. 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.

Lecture details

Type: Lecture
Level of difficulty: Detailed
Experience Level: Experienced
Desirable listeners function: DBA

About speaker

Best Sponsor

Better Sponsor

Good Sposor

University sponsor

Media Sponsor

HrOUG.hr

The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.

Follow us on Facebook

Follow us on Twitter

Keep yourself up to date with all updates!