Archives of the TeradataForum

Message Posted: Sun, 15 Sep 2002 @ 20:27:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

If the value is passed in as a parameter, the optimizer can't know what the value will be, so tends to optimize based on what a common value would be.

Yes, this means that sometimes the optimizer picks the wrong plan, and for this type of query it can be much faster to include the data in the SQL text where the optimizer can see it.

	<Prev	Next>		<<First	<Prev	Next>	Last>>