Analyzing sysptprof

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

Sorry, I reversed isreads and seqscans, just a type-o "Bjorn De Waele" <bjornREMTHIS@pandora.Be> wrote in message news:FVFWd.31036$Zr1.3140715@phobos.telenet-ops.be... > 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 >