From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Jeff Davis <jdavis-pgsql(at)empires(dot)org> |
Cc: | Paul Ganainm <paulsnewsgroups(at)hotmail(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Firebird and PostgreSQL at the DB Corral. |
Date: | 2003-12-21 13:24:17 |
Message-ID: | 20031221132417.GA26760@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Dec 20, 2003 at 04:14:51PM -0800, Jeff Davis wrote:
> > >
> > > What, exactly, is a partial index? A functional index is an index on
> > > something like ((ColumnX*2)/14)? I think the functional one (is that
> > > also an expression index?) is on the way.
> >
> > A partial index is a index on a subset of a table. The case I can think of
> > is a list of transactions, some of which are yet to be billed. They have a
> > BillID field which is NULL. since this is the recent set it is queried quite
> > often, so you can build an index like:
> >
>
> Are NULLs even indexed?
No, but with a partial index you can acheive the same effect.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> (... have gone from d-i being barely usable even by its developers
> anywhere, to being about 20% done. Sweet. And the last 80% usually takes
> 20% of the time, too, right?) -- Anthony Towns, debian-devel-announce
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Thomas | 2003-12-21 13:37:32 | Re: MySQL Gets Functions in Java - Enlightenment Please |
Previous Message | Gaetano Mendola | 2003-12-21 12:56:43 | Re: [GENERAL] Backwards index scan |