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

From: Robert Freeman <>
Date: Mon, 16 Apr 2018 02:40:40 +0000
Message-ID: <>

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

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

Received on Mon Apr 16 2018 - 04:40:40 CEST

Original text of this message