Since I am using P10 (10.13.043) I have bad performance when I run several queries in PCC. If I run it in an ODBC based tool the performance is much better. Now I found out by using the Query plan viewer that in addition to my query a second query run which is similar to the original one but with a count. Unfortunatly this count query is needing so much time and for some of my queries the result could not be realy good (e.g. my query has TOP 1 so record count of the result is1 or 0, but the count statement gives all records).
In on special case with a group by and Sum(Distinct(.. the count query crashes the engine.
So my question is, if there is a possibility to supress this count query in PCC?