I have created a local view on a table that contains around 400,000 records in it. Whenever I issue a requery on the table, it takes several seconds to bring up the information. Is there some way to speed of the query. I have created an index on the key field of the table, but I'm not sure that it is being used with the query.
Any suggestions?

Thanks.