Johan De Meersman Re: Hi, how did u do de-emphasis of sql statements?
Aug 13, 2012; 14:48
Johan De Meersman
Re: Hi, how did u do de-emphasis of sql statements?
----- Original Message ----- > From: "MID.night" <693893465@qq.com> > > Like select * from table where name>=E2=80=99A=E2=80=99 is just > > The same as select * from table where name>=E2=80=99B=E2=80=99.
The execution plan for both statements is indeed likely (but not guaranteed!) to be the same. As far as I'm aware, though, MySQL does not bother about that, though, as there is no execution plan cache.
The query result cache does not equate the statements - it works based off the EXACT query text, INCLUDING spaces and capitalization.
When analyzing various logs, the Maatkit/Aspersa/Percona toolset does transform SQL statements into their canonical form, though; so if you're looking for ways to do that you can have a look at how it's done there.
-- Linux Bier Wanderung 2012, now also available in Belgium! August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Aug 20
Rick James RE: Hi, how did u do de-emphasis of sql statements?
Aug 20, 2012; 10:57
Rick James
RE: Hi, how did u do de-emphasis of sql statements?
Aug 13
MID.night Hi, how did u do de-emphasis of sql statements?
Aug 13, 2012; 17:54
MID.night
Hi, how did u do de-emphasis of sql statements?
Aug 13
MID.night Hi, how did u do de-emphasis of sql statements?
Aug 13, 2012; 17:54
MID.night
Hi, how did u do de-emphasis of sql statements?
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!