> > 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.
Yes, thanks Tom. This is precisely what I was missing. I searched the archives for the reason why this is so, but I found only one message mentioning the MVCC mechanism. Can you point me in the right direction? I would like to understand the issue. IMHO, a change in this area could deliver great performance improvements. -Tiago ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
