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 [EMAIL PROTECTED])
