On Thursday 19 Jun 2003 6:37 am, Avi Schwartz wrote:
> Hi,
>
> We have a table, lets say of products. Some products get deleted from
> time to time, using a soft delete (i.e. they have a date deleted
> attribute which is set when the the record is deleted. We never
> physically delete the records. Is there a way that table inheritance
> can be used to help us speed up queries?
You might find a partial index to be of use. Something like:
CREATE INDEX my_index ON products (prod_id) WHERE delete_date IS NULL;
--
Richard Huxton