On Fri, Jan 19, 2007 at 15:22:12 -0500,
Jan Muszynski <[EMAIL PROTECTED]> wrote:
> 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=
>
> Will index1 still be used, or am I looking at a seqscan u
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=
Will index1 still be used, or am I looking at a seqscan under all
circumstances in this case?
TIA
-jan m
---(end of broadcast)-
