The Forgotten Performance Tuning Trick - Clustering your Data
Track
DBA & Infrasturcture
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
About speaker
Martin Widlake, author
Martin Widlake is an independent Oracle consultant who has been working with the database since 1992, mostly as a development DBA, database designer and performance engineer.
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.