On Sat, 10 Jan 2015 01:44:35 +0100, Bernd Oppolzer <bernd.oppol...@t-online.de> wrote: > >It is normal practice at the shops I work to do EXPLAIN regularly on all >programs that go into production and to store the PLAN TABLE results >for later trouble shooting ... if there is trouble. The developers at >our sites
Probably 20 years ago one of our DBAs added a step to the migration process that checked the plan table in the QA environment, looking for certain obvious problems. For example a tablespace scan on a table larger than x. Such packages were flagged and migration to production halted, IIRC. It didn't catch everything, but it was helpful. Scott ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN