Re: any way to speed up count(*)?

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Thu, 26 Nov 2009 21:32:54 +0100
Message-ID: <4b0ee5f3$0$2858$ba620e4c_at_news.skynet.be>



Volker Borchert wrote:
> Shakespeare wrote:
>> Most times, these queries are generated by some tool that needs a where
>> clause anyway, and 'AND's or 'OR's the user specified clauses to it, and
>> they put in the 1=1 for when a user does not enter any condition..
>
> Surprisingly, the optimizer sometimes seems to do a bad job about such
> constant clauses. As in "where 1 = 2" resulting in a full table scan...
>

You're kidding, right? Received on Thu Nov 26 2009 - 14:32:54 CST

Original text of this message