Archives of the TeradataForum

Message Posted: Tue, 05 Sep 2006 @ 13:35:10 GMT

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

Oracle has a sort of extension to its SQL allowing users to influence the execution plan by "hinting" the optimizer.

Example:

     SELECT /*+ no_parallel(t1) no_parallel(t2) no_parallel_index(t1)
     no_parallel_index(t2)
     ordered use_nl(t2) index(t1,t1_abc) index(t2,t2_abc) */ COUNT(*)
     FROM t1, t2
     WHERE t1.col1 = t2.col1;

Everything between /* and */ is called a "hint".

Teradata has nothing like that.

Victor

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