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

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