Re: Efficient date range search?

On 7 Oct 2002 at 13:32, Jean-Luc Lachance wrote:

> > select * from pets where died > [date] or died is null;
> Then you're back to whole table scan... :(

Well, if there is an index on died, it's rather an indexed scan as opposed to a 
sequential scan as you are mentioning(hopefully).

Indexed scan are usually pretty quick if you select small amount of data from 
entire table set. e.g.  10 pets from a million tuples..

Bye
 Shridhar

--
character density, n.:	The number of very weird people in the office.