An overview of the IBM Informix Dynamic Server optimizer

Level: Introductory

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

01 Nov 2002
Updated 11 Jul 2005

	Get the download

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

	Information about download methods			Get Adobe® Reader®

About the authors

		Samar Desai is an Informix Database Developer at IBM.

		Nita Dembla is an Informix Database Developer at IBM.

Rate this content

Please take a moment to complete this form to help us better serve you. Did the information help you to achieve your goal? Yes No Don't know   Please provide us with comments to help improve this page:   How useful is the information? 1 2 3 4 5 Not useful Extremely useful

Back to top