On Sat, 10 Jan 2015 14:40:19 +0100, Bernd Oppolzer bernd.oppol...@t-online.de
wrote:
for batch programs, a table space scan on large tables may well be
the best access strategy, if the related SQL is the overall cursor
controlling
the batch program, and if large portions of the table is used. So
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
Speaking as a developer. A few years back we used to pass all new (or
troublesome) queries through Visual Explain. We LOVED it. It dramatically
improved our ability to tune queries before we implemented them.
Then our internal software police took Visual Explain away from us and made
us use