Re: result of onstat -g sql xxx

Posted in 2000

Mark D. Stock — Wed, 05 Jul 2000 20:06:21 +0100 — source: Informix-list mailing list archive (1991-1998)

Daniel Willems wrote: > > Created by BaaN is the following sql statement: > > UPDATE {+ INDEX( tiitm0011001abaan) } "baan".tiitm001100 SET t_llci > = ?,t_mrpi = ? WHERE t_item= ? Oh PLEASE don't tell me Baan are using Optimiser Directives, please! :-( > Is Infomix using index tiitm0011001abaan when updating table > "baan".tiitm001100 ? If index tiitm0011001abaan is on column t_item then yes, it will use it to find the records to update. Why this would need forcing though, is another question, unless they expect the statistics to be out of date. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+