An overview of the IBM Informix Dynamic Server optimizer

This 30-page paper gives you a basic understanding of the Informix Dynamic Server (IDS) optimizer, including query rewrite, plan generation, the role of statistics, and optimizer directives.

Samar Desai (samard@us.ibm.com), IBM Informix Database Development, EMC

Samar Desai is an Informix Database Developer at IBM.



Nita Dembla (nita@us.ibm.com), Informix Database Developer

Nita Dembla is an Informix Database Developer at IBM.



11 July 2005 (First published 01 November 2002)

This 30-page paper gives you a basic understanding of the Informix® Dynamic Server (IDS) optimizer, including query rewrite, plan generation, the role of statistics, and optimizer directives.

Summary minor heading

The role of the optimizer component of the IBM Informix Dynamic Server (IDS) is to evaluate possible query execution plans and decide on the best plan based on heuristic rules as well as on cost. This 30-page paper provides a basic understanding of the IDS optimizer.

The paper begins by explaining how the optimizer fits into the SQL engine. It defines terms, then goes into a detailed discussion of the optimization process, including query rewrite, plan generation, explain, directives, and the role of statistics. It also covers distributed query processing, view processing and fragment elimination.

Download

DescriptionNameSize
Article in PDF format0211desai.pdf84KB
static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=299802
SummaryTitle=An overview of the IBM Informix Dynamic Server optimizer
publish-date=07112005