Re: OT: IDS 10 QPlan sanity failure problems

Well, the truth is I didn't specify "for procedure" the first time but I did it this time and still the same problem appears. I'll drop and recreated all problematic procedures and hope it works. I also contacted my local support, maybe they'll know the solution. "scottishpoet" <dryburghj@yahoo.com> wrote in message news:1127217937.510858.314160@z14g2000cwz.googlegroups.com... > what update statistics did you run > > If you didn't specify "for procedure" it would not have updated the > query plans for the procedure > > Personally, I'd drop and recreate the procedure.

surprised that didn't work! there was a change to the query plans after 9.40.UC4 which means the plans all need updated and the update statistics for procedure requirement should be documented. Are you using ER?

No, no ER, HDR or anything like that... I'll search through release notes, defect notes etc. for v10, maybe it really is documented. "scottishpoet" <dryburghj@yahoo.com> wrote in message news:1127231331.200732.213480@g43g2000cwa.googlegroups.com... > surprised that didn't work! there was a change to the query plans after > 9.40.UC4 which means the plans all need updated and the update > statistics for procedure requirement should be documented. > > Are you using ER? >

the requirement to run aupdate statistics for procedure is supposed to be documented in the IDS 10 migration guide if its not then its a docs bug