Re: [HACKERS] PG 7.4.3 optimizer choosing sequential scan. Why?

2004-07-26 Thread Greg Stark
Barry S [EMAIL PROTECTED] writes: * The table contains one index: P1_NRN_ROAD_V (v, sobjid) (The index includes the column sobjid because the query projects this col, and its inclusion in the index allows it to be serviced without accessing the underlying table) (Unlike Oracle) Postgres

Re: [HACKERS] PG 7.4.3 optimizer choosing sequential scan. Why?

2004-07-25 Thread Barry S
* The table contains one index: P1_NRN_ROAD_V (v, sobjid) (The index includes the column sobjid because the query projects this col, and its inclusion in the index allows it to be serviced without accessing the underlying table) Now, for the queries: QUERY 2: select sobjid from p1_nrn_road