Re: Index question

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: Jernej Kos <kostko(at)jweb-network(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Index question
Date: 2004-06-07 17:04:00
Message-ID: 5.2.1.1.1.20040608010214.02fc7e80@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 04:39 PM 6/7/2004 +0200, Jernej Kos wrote:

>I have a query which orders data like this: ORDER BY a.col1, b.col2 where a
>and b are different tables. Both tables are really big and so, ordering takes
>quite a while. Now i would like to create an index to speed things up, but i
>don't know how to create such an index that would cover both columns in
>different tables.

How about creating two indexes. One index for each column of the DB.

Try it. It could still speed things up.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2004-06-07 17:04:08 Re: postgres on SuSE 9.1
Previous Message Lincoln Yeoh 2004-06-07 17:00:35 Re: Backup and Restore of PostgreSQL