Re: Query for sequencial scan
In article <34902078.6F9B@bloomberg.com>, "Art S. Kagel"
<kagel@bloomberg.com> writes
>Serafim Fonseca wrote:
>
>> Some time ago, someone posted a sql query to a sysmaster table
>> that showed which tables were sequentially scanned.
>> Is it possible to post it again?
>
>IIUG has this entire news group archived. If noone responds soon
>check out the IIUG homepage (www.iiug.org).
>
>Art S. Kagel
Look at $INFORMIXDIR/etc/sysmaster.sql.
Search for seqscans.
I think it is sysptnprof, systabprof? Something like that. Then match
up the partnum to
select tabname,hex(partnum)
from systables
order by 2
--
David Williams