>
> What are the results of:
>
> SELECT S.REGIONID, Count(*) FROM Site S GROUP BY 1

Good - PLAN (S ORDER IDXSITE_REGIONID)

------ Performance info ------
Prepare time = 0ms
Execute time = 1s 31ms