Index question

От:

Jernej Kos <kostko@jweb-network.net>

Дата:

7 июня 2004 г. в 11:42:18

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 
JWeb-Network

Re: Index question

От:

Lincoln Yeoh <lyeoh@pop.jaring.my>

Дата:

7 июня 2004 г. в 14:03:20

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.