Archives of the TeradataForum

Message Posted: Wed, 21 Jun 2006 @ 23:01:43 GMT

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

DISABLE PARSING on the ODBC driver only prevents the ODBC driver from parsing the Query - it has no effect on parsing in the database itself.

(If you are running it from SQL Assistant it has no effect on ODBC either since that switch is overriden by SQL Assistant based on your setting of the 'Allow use of ODBC SQL Extensions' option.)

The database has to parse the query in order to execute it.

If you are going to run the same query multiple times (maybe with different data values) you might benefit from turning it into a macro (with parameters).

The first execution will still take a long time but the later executions might find the 'plan' in the cache, and avoid most of the parsing.

Mike Dempsey
Teradata Client Tools

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