Re: Not using index

From: Crispin Miller <crispin(at)cs(dot)man(dot)ac(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Joerg Hessdoerfer <Joerg(dot)Hessdoerfer(at)sea-gmbh(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Not using index
Date: 2001-02-07 16:39:55
Message-ID: 3A817A5B.5742022A@cs.man.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Tom, Jeorg,
Thanks for the help - I thought I might be being a bit vague...
Jeorg's suggestion solved my problem - I need to create an index across
both columns:

'create index foo on bar ( baz, bang )'

Like what Jeorg said I should :-)

Appreciated,
Crispin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-02-07 16:43:11 Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?
Previous Message Brice Ruth 2001-02-07 16:38:53 Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?