On Wed, Jul 25, 2001 at 12:03:59PM +0400, Artem V. Ryabov wrote:
Hello All,
When I use order by .. DESC in query, time always more then in
order by .. ASC case.
Explain say Using filesort,in DESC case query.
Why???
Because in 3.23.xx, MySQL doesn't know how to walk the index nodes
Hello All,
When I use order by .. DESC in query, time always more then in
order by .. ASC case.
Explain say Using filesort,in DESC case query.
Why???
Why I can't use key value in select like that:
select * from TableName where KEY(KEYNAME)concat('value1','value2')
or
select * from
Artem V. Ryabov writes:
Hello All,
When I use order by .. DESC in query, time always more then in
order by .. ASC case.
Explain say Using filesort,in DESC case query.
Why???
--
Best regards,
Artem mailto:[EMAIL PROTECTED]
Hi!
This is a known