> 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).
> productID = 1959201 and valuedate = '2004-04-01'
> GROUP BY
> saleprice, saleprice
> ORDER BY
Thank you all. I guess I got everything in my hands now ;-)