Conference Schedule – Subject to Change

   

Presentation Information

Presentation Title:   How to Get High Performance from Dynamic SQL
Primary Speaker:   Alex Cheng
Bio:   Alex Cheng is an IT veteran starting his professional career as a programmer in 1976 at a large bank, which is now part of Bank of America. From there, he worked as a developer, system analyst, database administrator, project leader at several large companies including ExxonMobil, Shell Oil, EDS and Compaq Computer. Currently, he is the manager of Database Architecture and Administration at Insperity. Alex received his masters degree from University of South Carolina at Columbia. He is also the holder of ICDBA (IBM Certified DBA), MCDBA (Microsoft Certified DBA), MCSE (Microsoft Certified Systems Engineer), CDP (Certificate in Data Processing from Institute of Certification for Computer Professionals) and CTM (Certified Toast Master). He has been a frequent and popular speaker at the IIUG Conference, IDUG (International DB2 Users Group) Conference, PASS Summit (Microsoft SQL Server Conference) and ISUG (International Sybase Users Group) Conference.
Presentation
Abstract:
  
Is it possible to get high performance from dynamic SQL? The
answer is both yes and no, depending how dynamic SQL codes
are used. The conventional wisdom argues against using
dynamic SQL, versus using static SQL, for good reasons. In
static SQL, SQL statements are parsed, validated and
optimized only once at compile time. In dynamic SQL, SQL
statements are constructed and their query plans generated
in run time. Your queries or stored procedures will have bad
performance if dynamic SQL is not used correctly and
efficiently.

The purpose of this session are two-fold: 1) to show you the
best practices when dynamic SQL should be considered and
used; 2) to demonstrate performance techniques how to
achieve high performance from dynamic SQL. Even though we
should use static SQL in most cases, we can consider using
the dynamic SQL to handle the highly complex business
processing where stored procedures have many input
parameters and those parameters may or may not be used. SQL
statements need to be constructed differently, depending on
whether or not input parameters are supplied in run time.
The big challenge of using dynamic SQL is to get its query
plans, which seems to be impossible. You definitely need SQL
execution plans to see how well your queries perform. This
session will show you how to get query plans and achieve
high performance from dynamic SQL.
Co-Speakers
or Panelists:
  
None