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

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 11 Apr 2018 13:40:42 +0100
Message-ID: <CABe10sYp70CCk0qPLNfk65J49r1bK4H5G0g0R_6Evr7OXHuk4w_at_mail.gmail.com>



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_at_gmail.com> 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_at_maresh-usa.com" <jeff_at_maresh-usa.com>.
>
> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 11 2018 - 14:40:42 CEST

Original text of this message