Writing efficient SQL statement

Track

DBA

Datum i vrijeme

četvrtak, 20. listopad 2016., 09:00

Dvorana

Dvorana B

Trajanje

45'

A lot of developers think that the performance of SQL statement depends merely on the quality of execution plan prepared by the Optimizer. This is only one side of the story. The other part of the story is even more important but unfortunately frequently totally neglected. It is related to the fact how efficient are the access paths to our data and the way how the SQL statement was coded. Writing efficient SQL statement requires some knowledge about SQL language intricacies, knowledge about the underlying data model and also some facts about the Optimizer. In this presentation we will discuss the required approach for preparing efficient and performant SQL statement. Of course we will also discuss available diagnostic mechanisms which can help us when things go in the wrong direction.

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!