Query Retrieval

Hi Folks: I am working on improving the query performance in informix 7.1. I already have unique indexing on this table and besides optimizing the query, virtual processor technique, is there any other technique that can be employed to improve the query retrival time in informix. Thanks in advance -- Sriramasundararajan Rajagopalan Software Engineer Network Products & Services GE Medical Systems ------------------------------------------------------------- Office | Home | 16705 W. Lincoln Avenue | 3459 S. 110th Avenue New Berlin, WI 53151 | Apartment # L203 Phone: (414)827-3372 | West Allis, WI 53227 Fax: (414)827-3363 | Phone: (414)545-3178 Email:rajagopa@nps.med.ge.com | Fax: <<< COMING SOON >>> ------------------------------------------------------------- ---------------------------------------------------------- Quote of the Week: Success is not a desination but a journey ----------------------------------------------------------