On Thursday 18 December 2003 03:53, Paul Ganainm wrote:
> kleptog@svana.org says...
>
> > Now an index can be used on customer when searching for only unbilled
> > things whereas normally it would also have to search for all historical
> > things as well.
> >
> > So, you get the benefit of a smaller index that is more useful to boot.
>
> Hmmm... this is kinda like the Oracle thing where tables can be
> partitioned? Sort of?
Not really (other than it's a performance thing). It is very useful when you
know most queries are only interested in a certain set of values.
--
Richard Huxton
Archonet Ltd