Whitepaper : SQL Syntax and Query Performance

A query that runs well on a local set of test data can fail miserably on a production system. Very often, a simple change in the syntax can make a huge performance difference. Much of the advice concerning SQL is ‘it depends’ because tuning a database is both art and science. In this whitepaper, learn about some principles that you can follow that should produce good SQL most of the time and give you a maintainable schema.

Topics :

Products :

Joe Celko

Mr. Joe Celko serves as Member of Technical Advisory Board of Cogito, Inc. Mr. Celko joined the ANSI X3H2 Database Standards Committee in 1987 and helped write the ANSI/ISO SQL-89 and SQL-92 standards. He is one of the top SQL experts in the world, writing over 700 articles primarily on SQL and database topics in the computer trade and academic press. The author of six books on databases and SQL, Mr. Celko also contributes his time as a speaker and instructor at universities, trade conferences, and local user groups

SQL Query Tuner

  • Granular wait state monitoring
  • Continuous SQL sampling
  • Intuitive drill down to view top activity
  • Query plan tuning and recommendations
  • Lock and latch resolutions
  • Storage visibility and contention resolution

Start for Free