From: Vladislav Vaintroub
Date: February 18 2009 9:50pm
Subject: RE: Patch for bug#42208
List-Archive: http://lists.mysql.com/falcon/560
Message-Id: <00b701c99212$ead9d1e0$c08d75a0$@com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: QUOTED-PRINTABLE



> -----Original Message-----
> From: Ann.Harrison@stripped [mailto:Ann.Harrison@stripped] On Behalf =
Of
> Ann W. Harrison
> Sent: Wednesday, February 18, 2009 10:34 PM
> To: Vladislav Vaintroub
> Cc: Kevin.Lewis@stripped; 'Lars-Erik Bj=F8rk'; 'Jim Starkey'; 'Falco=
nDev'
> Subject: Re: Patch for bug#42208


Thanks all for the answers. I do recall now unique check was a big
performance killer.

> > select name order by  name, age where name like 'A%' and age  > 1=
0
> > can be answered just using index on (name,age)

> The double precision representation of 10 is precise, so there's
> no problem with that query.
>=20

Ok, I had to formulate the query a la Philip into
select name order by  name, age where name like 'A%' and age > 10 and=
 age  <
9007199254740993=20