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

  • From: Paul Drake <bdbafh@xxxxxxxxx>
  • To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • Date: Wed, 11 Apr 2018 13:18:13 +0000

Niall,

Thanks for that blast from the past.

The only emails I've seen from Nuno lately are on the Old Tools list
related to hand tool woodworking.

Paul

On Wed, Apr 11, 2018, 8:42 AM Niall Litchfield <niall.litchfield@xxxxxxxxx>
wrote:

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: