Oracle-L: Re: Avoiding full table scan

From: Tim Gorman <tim_at_sagelogix.com>
Date: Thu, 09 Oct 2003 17:09:25 -0800
Message-ID: <F001.005D2981.20031009170925@fatcity.com>

Same author (Jeff Maresh) has also published a new paper on physical structure of data warehouses to accommodate the life cycle of data. It is fantastic.

I¹ve published both papers (³Managing the Data Lifecycle² and ³In Defense of FULL table scans²) on my website at ³http://www.evdbt.com/papers.htm². The ³FULL table scan² paper is excellent, but I think the ³Data Lifecycle² paper is ground-breaking, covering topics that have not yet been treated appropriately. I highly recommend them both...

on 10/9/03 10:54 AM, Goulet, Dick at DGoulet_at_vicr.com wrote:

> Jack,
>  
>     In a recent copy of SELECT magazine there is a discussion in defense of
> full table scans.  I believe you might find it VERY interesting.  Although I
> was aware of some of what the author spoke he put it in a vein that makes
> extreme sense.
>  
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA

>>
>> -----Original Message-----
>> From: Jack van Zanen [mailto:JACK_at_QUANTSYSTEMS.NL]
>> Sent: Thursday, October 09, 2003 10:49 AM
>> To: Multiple recipients of list ORACLE-L
>> Subject: Avoiding full table scan
>>
>>
>> Hi All,
>>
>>
>> I wish to avoid a full tablescan on the following data
>>
>> V. Zanen
>> Zanen
>> Van Zanen
>> ...
>> ...
>> ...
>> Lot's more data
>>
>>
>> Select * from table where upper(name) like '%ZANEN%'
>>
>> I could create a function based index on upper(name) but this does not take
>> care of the % and like operator.
>>
>> Oracle has this (I believe it's called) context stuff that you can index
>> varchar fields etc. Is this the (only possible?) way to go??
>>
>> TIA
>>
>>
>> Jack

>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Oct 09 2003 - 20:09:25 CDT