select seqscans from sysptprof

does this counter include range sarageable sequential scans? ie partial table scans.

I don't think there is such a thing as a partial table scan. Any scan that avoids all indexes will have to access all pages in the table, otherwise how will the engine know that it has found all of the rows it is looking for? I can see a range scan using an index to scan across the index leaf pages, but that is not a sequential scan. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Jun 1, 2010 at 4:42 AM, ROBERT CLOW <robert@clow.biz> wrote: > does this counter include range sarageable sequential scans? ie partial > table > scans. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636e1f81f1358840487f5f1d6

Thanks Art. The only senario I could come up with was when we had a clustered index... Read the index for the start rowid then scan the table until out of range.. but didn't know in IDS did this (and I probably should know this) Anyway you have solidified my knowledge thanks again