The SQL Tuning Checklist: Making Slow Database Queries a Thing of the Past
Jeff Bailey, Tatyana Petrova · 2013
The SQL query had been running for 36 hours before it was killed. The project team is panicking. The customer is upset. What can you, a SAS ® programmer, do to get out of this dilemma? Something has to be done, but what? Chances are you have been there. You have felt the pain. You have lived through the helplessness and fear of imminent failure. Fortunately, it is possible to get out of this mess. This paper will show you the steps (and the mindset) required to solve this all-too-common problem. This paper includes examples from DB2, Greenplum, Oracle, and Teradata.