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

Vrsta: Predavanje
Razina težine: Srednje detaljno
Poželjno iskustvo slušatelja: Iskusni (2-3 g.)
Poželjna funkcija slušatelja: DBA

O predavaču

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.

Prati nas na Facebooku

Prati nas na Twitteru

Sve novosti i zanimljivosti vezane uz HrOUG objavljujemo na Twitteru!