Description:
Hello,
We reported a problem about selecting fields that some of them didn´t belong to
the used index on September.
We have already installed MySql 4.0.4 and we have a similar problem
(and also we are still having the original problem) when we select fields which some
Rafa,
I fixed the optimization of the ORDER BY ... LIMIT 50 query on the generated
'clientes' table you sent in September. The fix is in 3.23.53. It will favor
index range scans even more over full index scans.
But the underlying problem is in the MySQL optimizer. It does not realize
that it
Description:
Hello,
I wrote the following text in my last message (It was an answer to Monty):
Hello,
Monty
I have already sent to pub/mysql/secret the table definition and data
(clientes.txt)
and my.ini file in a compressed file named clientes.zip.
You can
Hi!
r == rafarife [EMAIL PROTECTED] writes:
cut
rAnd now, the explain selects:
r 1) Slow query
r explain Select Cod,Nom,Nif,Nombre_comercial from Clientes
r Where (Nom = 'GARCIA MANCILLA,S.L' And Cod'061642')
r Or Nom'GARCIA MANCILLA,S.L' Order by Nom ASC, Cod ASC Limit
Hi!
rafarife == rafarife [EMAIL PROTECTED] writes:
rafarife Description:
rafarife Hi Heikki,
rafarife I'm Lourdes and I work with Rafa in the MySQL project.
rafarife We have done what you have told us. We have run SHOW STATUS before
rafarife the query and we have obtained the next result:
Description:
Heikki,
1) There is only one record with 'GARCIA MANCILLA,S.L'.
2) Mysql reported 53 scanned rows when I ran your mock-up query on your mock-up
table. This is ok.
3) I'm using mysql.exe client (sometimes I use front-end) and i don´t think it
removes the LIMIT 50
