On 20/06/2011 07:35, Vladimir Kulev wrote:
> But this does not work:
> # explain analyze select max(timestamp) from sms where number in
> ('5502712','5802693','5801981');
Try to rewrite that query this way:
explain analyze select timestamp from sms where number in
('5502712','5802693','5801981') order by timestamp desc limit 1;
Regards
Gaetano Mendola