Re: Index Fast Full Scan and associated wait

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 11 Jan 2007 17:39:42 -0000
Message-ID: <ioydnUt4FY1M6zvYnZ2dnUVZ8sWhnZ2d@bt.com>

"EscVector" <Junk_at_webthere.com> wrote in message news:1168531840.130757.22890_at_77g2000hsv.googlegroups.com...
> I'm bottlenecked on db file sequential read. What wait should I expect
> to see if the plan shows Index Fast Full Scan? Is it db file
> sequential read or scattered read since the Fast Full Scan is treated
> like a tablescan and uses multiblock reads?
>

Typically "db file scattered read"
see
http://jonathanlewis.wordpress.com/2006/12/15/index-operations/

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Received on Thu Jan 11 2007 - 11:39:42 CST