Online V4.0 Optimizer

Path: emory!samsung!uakari.primate.wisc.edu!doug.cae.wisc.edu!umn.edu!spool.mu.edu!uunet!mcsun!unido!ixos!jochen From: jochen@ixos.de (Jochen Hager) Newsgroups: comp.databases.informix Message-ID: <1428@ixos.de> Date: 20 Mar 92 14:13:13 GMT Organization: iXOS Software GmbH, Munich, Germany Hello Informix Specialists! Again and again we encounter optimizing unpredictables with Informix Online V4.0. I know this is a very vague question but: Does anybody know which strategies are used by the Informix Online optimizer? If anybody knows tricks to outsmart the optimizer please send me a message, especially as to how Informix makes use of user defined indices. Thank You. My address is ------------------------------------------------------------------- Jochen Hager Tel.: (0041)(89) 46005-0 iXOS Software GmbH Munich Fax: (0041)(89) 46005-99 Bretonischer Ring 12 email: JOCHEN.HAGER@ixos.de W-8011 Grasbrunn/Muenchen Germany -------------------------------------------------------------------