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

Did you ask him if an index fast full scan would suffice instead of a range scan?

Shhhhhhh...... I am hunting dinosaur.....

Robert G. Freeman
DBA, Troublemaker, Malcontent
Businessolver

> On Apr 10, 2018, at 11:14 AM, Ls Cheng <exriscer_at_gmail.com> wrote:
>
> 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