Hi all,

I followed the "select count(*) is slow" thread a bit and would like
to add the following side-question to it.

(As posted before) I have an SQL select statement with a number of
joins - pretty complicated - which performs the SELECT * FROM ... in
0.0300 secs. To my surprise, the same statement modified to do a
SELECT count(*) from ... takes more than 5 secs - this is more than
150 times slower!

Does anyone have an explanation for this? For the details of the
query see my previous post with "horrible performance" in it.

Mirco