Re: index skip scan

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Mon, 12 Jan 2009 09:36:17 +0100
Message-ID: <496b0108$0$196$e4fe514c_at_news.xs4all.nl>

Jonathan Lewis schreef:
> "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).
>
>
>

Ok, thank you!

Shakespeare Received on Mon Jan 12 2009 - 02:36:17 CST