Hi, how did You get these times??

Did You run it in IBExpert???

If so, try to run the first query as Fetch All, maybe this is the reason.

Tom

--- In firebird-support@yahoogroups.com, "kadriizer" <kadri@...> wrote:
>
>
> ------ Performance info ------
> Prepare time = 0ms
> Execute time = 16ms
>
> This query, "select * from" portion, as "select count (*) from" is changed, the performance information is as follows ...
>
> ------ Performance info ------
> Prepare time = 0ms
> Execute time = 1s 904ms
>
> First query is faster than second query! Why?
>
> Kadri.
>