> The indexes worked as yourself and Paul suggested! Thank you again for the > advice! > Question...Does rushmore also work on HAVING clauses in the select > statement? What about in GROUP BY and ORDER BY clauses? I wouldn't think so, since these are not related to the Retrieval of the data, rather they are related to the processing of the data after it's been retrieved. Same thing with selecting N records or N % of the records -- FP has to select them all and then order & group them before it knows what the top N records are. /Paul