If I have an index that's composed of 2 columns:
Index index1 on tableA (foo,bar)
and I then:
Select cola, colb from tableA where foo=<value>
Will index1 still be used, or am I looking at a seqscan under all
circumstances in this case?
TIA
-jan m
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
