Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 05 Sep 2006 @ 14:46:56 GMT

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

Subj:   Re: Hints for Teradata Optimizer
From:   Victor Sokovin

  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.  

Hints is a separate discipline within Oracle. Mastering it can take a long time and if you want to stay on top you have to follow recent developments etc. Company's policy changes all the time, from declaring hints to be the last word in technology to outdated rubbish to a useful additional instrument for advanced users.

The hint above tells Oracle not to use parallelism while reading data from both tables, to use the specified indexes (but without parallelism) for the nested loop join of tables, in the above order of joining.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020