Thread: Index question

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

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.