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.

About the Presenter

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.

Download PDF
Share This
Contact IDERA:
Call toll-free in North America
1-877-464-3372
Call International
+1-713-523-4433