Re: OT: IDS 10 QPlan sanity failure problems

Posted in 2005

Davorin Kremenjas — Thu, 22 Sep 2005 08:46:46 +0200 — source: Usenet: comp.databases.informix

"scottishpoet" <dryburghj@yahoo.com> wrote in message news:1127310511.698732.213080@g47g2000cwa.googlegroups.com... > update statistics drop distributions will not fix the stored procedure> query plans so have little if any impact on your problem Yes, I've read the manual, it just clears sysdistrib so I wasn't hoping it would correct the problem with SPLs, but being desperate I ran it anyway... > If dropping the procedures and recreating them didn't resolve the > problem its time to contact your support provider I'll try that as a last resort, yes.