- Original Message -
From: "Kelvin Wu" <[EMAIL PROTECTED]>
To:
Sent: Saturday, January 13, 2007 11:04 PM
Subject: Index and Order By
I am looking for help and suggestion.
Mysql Ver 12.18 Distrib 4.0.12, for pc-linux (i686)
The table structure:
mysql&
Hi Kelvin, all!
Kelvin Wu wrote:
I am looking for help and suggestion.
Mysql Ver 12.18 Distrib 4.0.12, for pc-linux (i686)
The table structure:
[[...]]
I created multiple parts of Index for this table:
[[...]]
And here are the questions:
Q1: the query is supposed to use index bynone but ...
BTW, I have force to use index key by using USE INDEX (bysource) for
example, in the query, but it didn't look good to me...
--
Sent from my BlackBerry. Ignore the typos unless they're funny.
I am looking for help and suggestion.
Mysql Ver 12.18 Distrib 4.0.12, for pc-linux (i686)
The table structure:
mysql> desc article;
++--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-
Thank you Sasha for your answer.0
I still miss-understand index and 'order by'.
After creating multiples index on a 'Test' table, the current problem
is that mysql optimizer doesn't choose the right index.
Here is a small
Bernard Chambon wrote:
I try to understand index usage for 'order by'
but that's seemn hard to me.
Here is what I have tried :
1_ About documentation
I have read carefully related documentation (7.2.9 How MySQL Optimizes
ORDER BY) but
I don't understand it.
- What is the difference betwween 'ke
I try to understand index usage for 'order by'
but that's seemn hard to me.
Here is what I have tried :
1_ About documentation
I have read carefully related documentation (7.2.9 How MySQL Optimizes
ORDER BY) but
I don't understand it.
- What is the difference betwween 'key1' and 'key_part1' ?
