Re: Finding queries which result in sequential scans

On Wed, 19 May 2004 01:26:42 -0700, malcolm wrote: > I found that the best way to tackle this is to find all tables with a > large number of sequential scans (sysptprof linked to systabinfo) and > then discard the squential scans where the table has only a few rows. > That way you can identify the most common tables. > Next find the user doing the most sequential scans (syssesprof, > syssessions). It gives a lead into who and what is causing the > problem. Great suggestions, thanks! -- John Hardin KA7OHZ <johnh@aproposretail.com> Internal Systems Administrator voice: (425) 672-1304 Apropos Retail Management Systems, Inc. fax: (425) 672-0192 ----------------------------------------------------------------------- Failure to plan ahead on someone else's part does not constitute an emergency on my part. - David W. Barts in a.s.r