Subject Re: [ib-support] sql and speed
>>>>> On Thu, 25 Apr 2002 20:11:14 +0200, Duilio Foschi <dedalus@...> said:

DF> is this query select sum(qty) from table1

DF> faster than

DF> select sum(qty) from table1 where qty<>0

I doubt, if you do not have an index on `qty', I mean.

ciao, lele.
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.