RE: SQL performance problem

Posted in 2000

John Carlson — Wed, 6 Sep 2000 09:25:26 -0400 — source: Informix-list mailing list archive (1991-1998)

Post a schema of the table. John Carlson Informix DBA EDS - WHSmith USA 3200 Windy Hill Road, Suite 1500 West Atlanta, GA 30330 > -----Original Message----- > From: Maciej Zygmunt [mailto:zygmunt@agh.edu.pl] > Sent: Wednesday, September 06, 2000 5:13 AM > To: informix-list@iiug.org > Subject: Re:SQL performance problem > > > Hello, > I've a performance problem. > In my database there are about 800 000 records in > the biggest table. > I need count distinct records in this table joined with another. > And I have a dramatic decrease of performance: without 'distinct' > it is counted about 2 min, but with 'distonct' about 8 min. > > Does anybody have an idea what should I do? > > Thanks > Anna > >