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.