Re: Performance problem with simple query

Posted in 1999

Obnoxio The Clown — Tue, 25 May 1999 19:39:35 GMT — source: Informix-list mailing list archive (1991-1998)

From: Willaert Doris <doris.willaert@suzuki.be> > >AIX 4.2.1 >Online 7.3 UD6 > >This weekend we converted our database from version 5 to version 7.3. We >have noticed the following problem trying to execute the following select : >The estimated cost is to high. (The select takes 26 secs) We have run >UPDATE >STATISTICS !!! Yes, but did you run the correct ones? There are many more options with IDS. Specifically, you might want to check out the DISTRIBUTIONS clause. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com