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
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