On Wed, Jul 21, 2010 at 12:53 AM, A. Kretschmer < andreas.kretsch...@schollglas.com> wrote:
> In response to Elias Ghanem : > > Hi, > > I have a question concerning the uses of indexes in Postgresql. > > I red that in PG a query can not use more than one index per table: "a > query or > > data manipulation command can use at most one index per table". > > That's not true, but it's true for MySQL, afaik. > > > Andreas > -- > Andreas Kretschmer > Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) > GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99 > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > That is not true either, though MySQL is less good at using bitmap'ed indexes. 5.0 can use "merge indexes", -- Rob Wultsch wult...@gmail.com