Re: Analyzing sysptprof

Bjorn De Waele wrote: > 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 ? Possible. To identify which tables are seeing seqscans, yes. To determine whether the quantity is excessive, I'm uncomfortable. First I'd want to update stats and see if the rate of seqscans for each table remains at the same level. Then I'd like to try to trap the specific queries that are causing the scans to see if specific filter values are so pervasive in that table as to make a scan the most efficient route so that I really should not worry except to examine if I can optimize the query with a more efficient filter or (OK you got me on this one) another index that includes another column or reorders columns from another index to eliminate the scan. Art S. Kagel > Thanks a lot. > <SNIP>