Re: Analyzing sysptprof

Hello Art, I found the isopen key in sysprofiles. In fact, I'm about to tune my indices/tables. That's why I want to compare my seq scans vs my index usage on table level. Do you think this is possible ? Thanks a lot. "Art S. Kagel" <kagel@bloomberg.net> wrote in message news:422CDC7F.4070406@bloomberg.net... > Bjorn De Waele wrote: >> 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 :) > > That's the calc that I've seen posted before. Personally I prefer to > compare seqscans to isopens as that is once per query and the number of > seq scans versus number of queries I think is a more accurate predictor or > whether you have too many queries performing scans than comparing to > reads. > > Art S. Kagel