Re: index skip scan
Date: Tue, 6 Jan 2009 23:18:06 -0000
"Shakespeare" <whatsin_at_xs4all.nl> wrote in message
> what's the meaning of resc_io here? I googled but can not find any
> explanation for it. It might be a cause for Oracle to use the skip scan.
> It seems to go for plans with low resc_io... while googling I saw more
> examples of this behavior.
resc_io = resource cost for I/O.
Before CPU costing appeared, you had just resc and resp
(resp = response for parallel execution, which was (crudely speaking) resc / degree).
-- 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.htmlReceived on Tue Jan 06 2009 - 17:18:06 CST