>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.
Look at the SYS(3054) function in the help. Yuo can use it to determine what level of optimization you view has and what indexes are being used to optimize it.
Also, is the database located locally or on a network drive? This could be a performance bottleneck.
How many records are being returned by the view? It may be that several seconds is perfectly acceptable technically speaking. It is only unacceptable perceptionally speaking.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao