Index question

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.