Re: Hints in Practice

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 27 Aug 2006 11:12:29 -0700
Message-ID: <1156702349.926227.96250@i42g2000cwa.googlegroups.com>

Bob Jones wrote:
> > The following is perfectly valid Oracle syntax:
> >
> > SELECT /*+ Bob Jones is making an argument that doesn't hold water */
> > table_name
> > FROM user_tables;
> >
> > And if you don't believe me ... copy it into SQL*Plus.
>
> Hmmm, it didn't work until I changed it to:
>
> SELECT /*+ DA Morgan is lost in the ocean of hints.*/
> *
> FROM many_stars;

Catfight!

You guys have a lot of time on your hands eh? Received on Sun Aug 27 2006 - 13:12:29 CDT