The Forgotten Performance Tuning Trick - Clustering your Data
Track
DBA & Infrasturktura
Datum i vrijeme
četvrtak, 20. listopad 2016., 09:55
Dvorana
Dvorana B
Trajanje
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.
Detalji o predavanju
O predavaču
Martin Widlake, autor
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.
Najbolji pokrovitelj
Bolji pokrovitelj
Dobar pokrovitelj
Edukacijski pokrovitelj
Medijski pokrovitelj
HrOUG.hr
Konferenciju organizira Hrvatska udruga Oracle korisnika. Više o udruzi možete saznati na Hroug.hr.