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.