Did you ask him if an index fast full scan would suffice instead of a range
Shhhhhhh...... I am hunting dinosaur.....
Robert G. Freeman
DBA, Troublemaker, Malcontent
On Apr 10, 2018, at 11:14 AM, Ls Cheng <exriscer@xxxxxxxxx> wrote:--
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?