sqexplain sysmaster table

Posted in 2000

malc_p@my-deja.com — Fri, 10 Nov 2000 13:51:56 GMT — source: Informix-list mailing list archive (1991-1998)

OK I know it's undocumented, but we use this to monitor our users (can't use I-SPY as all connections are shm). We generally keep an eye out for high cost, high number of rows returned, and seqscans. The query is, the seqscans column tends to have value 0 for non- sequential, 1 for sequential (fx: alarm bells, especially with high costt / # rows returned); but what does a seqscans value of -1 mean? IFX techinfo pages useless. Malc Sent via Deja.com http://www.deja.com/ Before you buy.