Re: Anyone know any WP which explains about FTS vs Index Scan?

Thanks all for the pointers.

However no one has come across with some official oracle stuff? I searched as well but I cant find any.

TIA On Tue, Apr 10, 2018 at 8:57 PM, Paul Drake <bdbafh_at_gmail.com> wrote:

> https://searchoracle.techtarget.com/tip/In-defense-of-full-table-scans
>
> Author Jeff Maresh.
> It may have been published in IOUG.
>
> On Tue, Apr 10, 2018, 1:50 PM Reen, Elizabeth <dmarc-noreply_at_freelists.org>
> wrote:
>
>> Show him these videos or have him read the blog.
>>
>>
>>
>> https://www.youtube.com/channel/UCWeOtlakw8g01MrR8U4yYtg
>>
>>
>>
>>
>>
>> http://use-the-index-luke.com/blog/2014-07/finding-all-the-red-mms
>>
>>
>>
>> Liz
>>
>>
>>
>>
>>
>> *From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_
>> freelists.org] *On Behalf Of *Ls Cheng
>> *Sent:* Tuesday, April 10, 2018 12:14 PM
>> *To:* Oracle Mailinglist
>> *Subject:* Anyone know any WP which explains about FTS vs Index Scan?
>>
>>
>>
>> Hi
>>
>> I have a Dinosaur stating we must always use index range scan no matter
>> OLTP or DWH systems. This guys still lives in the late 90's and Oracle 7
>> (although he claims he is 18 years veteran expert from 7 up to 12c), the
>> thing is I cannot find any Oracle WP or similar in the docs which states
>> Full Table Scan is not evil except Tom Kyte (asktom). I have even demo-ed
>> him with a very simple two table join example with FTS and index range
>> effect when a large amount of data need to be accessed, still he says in
>> Oracle docs states that scattered reads (FTS) mist be reduced!
>>
>> Does anyone know any official pointer, in WP form or MOS support note
>> which talks about FTS vs index scans?
>>
>> Cheers
>>
>>
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l