>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.
Do you have SET DELETED ON?
If you do then do you have an index on deleted() in your table.
Do you have an index on any field that you involve in the query as a parameter?
Just my two cents...
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope