quite often hints can be avoided by just structuring your queries in a different way.
especially look at joins, temp/variable tables and filtering criterias...
only recently, I turned a query which can take a minuite or more to run down to about 3 seconds or less just by changing the order of the table joins...
--------------------
Procrastinate Now!