Re: onstat -p seqscans
tony edwards wrote:
>
> Hi,
>
> Does anyone know if the seqscans in an onstat -p increments for
> sequential scans on temporary tables ?
>
> Cheers, Tony.
Try the following sql to see which tables have seq_scans.
select dbsname, tabname, seqscans from sysmaster:sysptprof;
Kernoal