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@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *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
