Bernard,

Have you tried creating an index tag on the inv_date field? Make sure the index expression is the same as the expression in your WHERE clause e.g. INDEX ON YEAR(inv_date). Otherwise your query will not be optimized.

George