> Hi,
>
> One more suggestion :-)
>
> > select saleprice , count(saleprice)
> > from presence
> > where productID = 1959201 and valuedate = '2004-04-01'
> > group by saleprice
> > order by saleprice
> >
> > Then, I don't know how to trick the optimizer so that it picks the best
> > indice (not the one on SalePrice).
>
> SELECT
> saleprice,
> count(saleprice)
> FROM
> presence
> WHERE
> productID = 1959201 and valuedate = '2004-04-01'
> GROUP BY
> saleprice, saleprice
> ORDER BY
> saleprice

Thank you all. I guess I got everything in my hands now ;-)