Hello.
I'm new to this mailing list :+)
I created a mutilple-column index, say
create index col1_col2 on table_name (col1,col2)
Both col1 and col2 are mediumint unsigned.
explain select * from table_name where col1='value'
order by col1 DESC,col2 DESC
shows that the query is still
. There are 12 columns and about
10 rows in the table.
regards,
Peaw.
--- Jeremy Zawodny [EMAIL PROTECTED] wrote:
On Wed, Jan 30, 2002 at 06:21:20PM +, peaw peaw
wrote:
Hello.
I'm new to this mailing list :+)
I created a mutilple-column index, say
create index col1_col2 on table_name