Tiago Wright <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
