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 example
mysql> desc Test ;
+-+-+--+-+
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' ?
