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

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: Tim Gorman <tim.evdbt@xxxxxxxxx>
  • Date: Wed, 11 Apr 2018 13:40:42 +0100

Indeed and it was one of my original suggestions in the same year..
https://groups.google.com/forum/#!topic/comp.databases.oracle.server/OcT2fwA6HfY%5B1-25%5D
. Some ideas never seem to die.

On Tue, Apr 10, 2018 at 9:01 PM, Tim Gorman <tim.evdbt@xxxxxxxxx> wrote:

I have a white paper and presentation on the topic written by Jeff Maresh
from 2002.

The white paper is entitled "In Defense Of Full-Table Scans" and the
presentation is entitled "How To Improve Database Performance With Full
Table Scans".  My website is having problems at the moment so I can't post
them there, but HERE
<https://drive.google.com/file/d/11CEqI6NOsc8D49t2eKuXnM7WYdsXB5oK/view?usp=sharing>
is a download link for the white paper and HERE
<https://drive.google.com/file/d/1iKxH3j_JjvfODl_dWkeiIQo63KyH5tbh/view?usp=sharing>
is a download link for the presentation.  If anyone wants to communicate
with the author, his email is "jeff@xxxxxxxxxxxxxx" <jeff@xxxxxxxxxxxxxx>.

Hope this helps...





On 4/10/18 13:46, Hans Forbrich wrote:

Have you looked at



*http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-explain-the-explain-plan-052011-393674.pdf
<http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-explain-the-explain-plan-052011-393674.pdf>
/Hans *On 2018-04-10 1:37 PM, Ls Cheng wrote:

Thanks all for the pointers.

However no one has come across with some official oracle stuff? I searched
as well but I cant find any.

TIA





-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: