To be more explicit, let's say I have table with two fields a and b. If
I have an index on (a,b) and I do a request like "SELECT b FROM table
WHERE a=x", will Postgresql use only the index, or will it need to also
read the table page for that (those) row(s)?
It must read the table because of vis
Hi,
Just wondering... Is Postgresql able to use data present within indexes
without looking up the table data?
To be more explicit, let's say I have table with two fields a and b. If I
have an index on (a,b) and I do a request like "SELECT b FROM table WHERE
a=x", will Postgresql use only the i