RE: Patch for bug#42208

[Vladislav Vaintroub]

> -----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ørk'; 'Jim Starkey'; 'FalconDev'
> 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  > 10
> > 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.
> 

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