Jul 16, 2006 #1 signalsys Technical User Sep 5, 2005 44 CN What's the difference between "star" and "star_transformation" used as hints ?
Jul 17, 2006 #2 dbtoo2001 MIS Jun 18, 2001 415 US Star affects join order, star_transformation affects query rewrite. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/hintsref.htm#5574 http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/hintsref.htm#5511 Upvote 0 Downvote
Star affects join order, star_transformation affects query rewrite. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/hintsref.htm#5574 http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/hintsref.htm#5511
Jul 17, 2006 #3 dbtoo2001 MIS Jun 18, 2001 415 US http://download-west.oracle.com/docs/cd/B10501_01/em.920/a86647/gls.htm#433276 Upvote 0 Downvote