Re: : Postgres IX

From: Shaun Clements <ShaunC(at)relyant(dot)co(dot)za>
To: Shaun Clements <ShaunC(at)relyant(dot)co(dot)za>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: : Postgres IX
Date: 2005-04-01 09:28:47
Message-ID: 100F78F2B203444BB161BBA7077FF6131CD9D4@srldbexc003.relyant.co.za
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Or better yet.
Can anyone explain the use of indexing, effecting the performance of select
query, using INDEXED columns, and non indexed columns.

I.E.

Select from table where column1 = 'xxxx' and column2 = 'xxxxx'

WHERE COLUMN1 is indexed, and COLUMN2 isnt.

Thanks in advance

Kind Regards,
Shaun Clements

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaun Clements 2005-04-01 09:42:35 FW: Help with order by into a RECORD
Previous Message Philippe Lang 2005-04-01 09:28:26 PL/PERL with composite return values & PGSQL 7.4?