Index question

From: Jernej Kos <kostko(at)jweb-network(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Index question
Date: 2004-06-07 14:39:23
Message-ID: 200406071639.23867.kostko@jweb-network.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Regards,
Kostko.
--
Kostko <kostko(at)jweb-network(dot)net>
JWeb-Network

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Maarten Boekhold 2004-06-07 15:04:03 Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?
Previous Message Bricklen 2004-06-07 14:38:20 Re: COPY error handling