Re: Anyone know any WP which explains about FTS vs Index Scan?
Date: Wed, 11 Apr 2018 13:18:13 +0000
Message-ID: <CAPptggXGS6qF8c0ks-fgVYi8ohOe6gpxj3Taw7D2VBLnCDW4kQ_at_mail.gmail.com>
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_at_gmail.com> 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_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-lReceived on Wed Apr 11 2018 - 15:18:13 CEST