Re: index skip scan

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 6 Jan 2009 23:18:06 -0000
Message-ID: <oqKdnUlx-5o6e_7UnZ2dnUVZ8gidnZ2d_at_bt.com>

"Shakespeare" <whatsin_at_xs4all.nl> wrote in message news:4963cac3$0$187$e4fe514c_at_news.xs4all.nl...
>
> 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.
>
> Shakespeare

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.html

Received on Tue Jan 06 2009 - 17:18:06 CST

This message: [ Message body ]
Next message: Palooka: "Re: The duration of one single oracle job"
Previous message: jernigam_at_nospam.kochind.com: "Re: index skip scan"
Maybe in reply to: jernigam_at_nospam.kochind.com: "index skip scan"
Next in thread: Shakespeare: "Re: index skip scan"
Reply: Shakespeare: "Re: index skip scan"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message