Re: query the data in Informix very slow

Posted in 2000

Art S. Kagel — Fri, 04 Aug 2000 12:10:23 -0400 — source: Informix-list mailing list archive (1991-1998)

If you or your DBA run the query using dbaccess/sqlcmd what happens? When you run it using SET EXPLAIN ON; what does the sqexplain.out file contain? Have you/your DBA updated statistics to meet the recommendations in the Performance Guide? Did you READ the Performance Guide? Art S. Kagel Patrick wrote: > > I use Informix 3.31 ODBC driver. When I query the data from > the database, it nearly spends me more than 5 minutes. The > returned number of records should be zero. And the table > contains about 20,000 records. I use VB and ADODC. > > Any help and suggestions will be appreciated. > > * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful