-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 01/19/07 15:53, Jan Muszynski wrote:
> Rather simple question, of which I'm not sure of the answer.
>
> If I have a multiple column index, say:
> Index index1 on tableA (foo,bar)
>
> and I then:
> Select * from "tableA" where foo = <some value>
>
> Will index1 be used, or am I looking at a seqscan in all circumstances?
Yes, it will use the index.
However, in earlier versions, the lvalue & rvalue needed to match in
type to use the index.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFFsUzmS9HxQb37XmcRArY8AKDqzS5FeY1HwkSGeOlhQsjsdpAV5gCghiWj
R4e7rBWaAAGF25ZFhy1Elgc=
=Wkp8
-----END PGP SIGNATURE-----