Re: Optimizing performance

Luis Servan wrote:
>
> I'd like to know how can I optimize the time response of database queries
> from applications developed with Designer/2000

This may be obvious to most but...

Make sure you have indexes created for all tables referenced in explicit or implicit SELECT statements.

-- 

 ___   ___
|   | |   |    
|__#####__|    Jonathan C. Sell                     
jsell_at_bio.ri.ccf.org
 __#####__     The Department of Biostatistics       Phone: 
216-444-0585
|  #####  |    The Cleveland Clinic Foundation       FAX:   
216-444-8023
|___| |___|
[Quoted] 			         "Do or do not.  There is no 'try'."
                                              -Yoda