the table. 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,
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 u
