Practical SQL performance tuning, for developers and DBA’s

Date: 
Wednesday, 17 June, 2009 - 10:00 - 11:00
Speaker: 
Kurt Struyf

Objectives:
Understand the basic rules of writing performing SQL

Outline:
To index or not to index
Access paths explained
Predicate solving when and how
Suboptimal coding and their improvements
Other easy to use CPU saving techniques
Mips and money

Full Abstract:
This presentation is a PRACTICAL, HANDS ON way to SQL performance tuning and SQL improvement. When logically correct SQL will always return and answer, the statement might be expensive or cheap but is quite often suboptimal. This presentation will explain the ground rules to writing performing SQL and has numerous EASY-TO-FIX, REAL LIFE improvements. If you are a developer or a beginning DBA, you’ll gain an understanding to better SQL writing and tuning. If you are a more experienced DBA you’ll get a thorough refresh, learn something new and walk a way with an idea of “how to explain SQL to your developers”.

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023