Analyzing sysptprof

Posted in 2005

Bjorn De Waele — Sun, 06 Mar 2005 16:08:05 GMT — source: Usenet: comp.databases.informix

Hello everybody, I'm analyzing sysptprof database cause it gives is huge information on our table/index usage. I'm trying to detect the sequential scans but I'm not sure if I interpret it well. Is it correct that I need to do the following : (isreads/seqscans)* 100 to compare seqscans vs qty reads ? Cause I have one table which had only 1 isreads and 2 seqscans.... Or do I need to do the bufreads/seqscans* 100 ? I hope someone can clarify this, cause the manuals aren't always that clear on these topics :) Thanks in advance, Bjorn