Writing efficient SQL statement
Track
DBA & Infrasturktura
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
O predavaču
Jože Senegačnik, autor
Joze Senegacnik has more than 28 years of experience in working with Oracle products. He began in 1988 with Oracle Database version 4 while working for the City of Ljubljana, where he had charge over the city's municipal and geographic information systems.
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.