Tiago Wright <tiagowright@gmail.com> writes:
> For example, consider the view
> CREATE VIEW vw_lot AS
> �SELECT�productid,�lotid,�parentlotid,�lottype,�lotname,�productname
> ���FROM�lot
> NATURAL�JOIN�product;
> where productname is in the product table, and lotname in the lot
> table. I would be interested in creating an index such as
> CREATE INDEX ix_vw_lot ON vw_lot (lotname, productname);
What purpose would this serve that indexes on the separate tables
wouldn't serve?
> The index would be enough to cover 90% of the queries against
> lot the lot and inventory tables.
This sounds to me like you are suffering from a common misconception.
Postgres cannot answer queries from the contents of indexes alone.
regards, tom lane