Archives of the TeradataForum

Message Posted: Tue, 05 Sep 2006 @ 14:03:22 GMT

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

I am kind of interested to know how to read this hint b/w /* and */ - i.e what is it that I am trying to tell the Optimizer in this case.

     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;

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