-----Original Message-----
From: John Hardin [mailto:johnh@aproposretail.com]
Sent: Friday, May 21, 2004 6:50 PM
To: informix-list@iiug.org
Subject: 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
sending to informix-list