Index question

[Jernej Kos]

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 <ko****@jweb-network.net>
JWeb-Network

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Lincoln Yeoh]

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.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Lincoln Yeoh]

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.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)