[CLUE-Talk] SQL-99 inner joins

[Jed S. Baer]

On Thu, 12 Jun 2003 20:08:25 -0600
Jeffery Cann <fabian at jefferycann.com> wrote:

> Unfortunately, many RDBMS vendors include extensions to SQL which have
> the advantage of performance.  For example, Oracle includes a way to
> give hints to the optimizer (aka 'planner' as Scott called it the other
> night).  These hints tell Oracle to use an index that it may not choose
> on its own, and hence the query performs faster.

Heh. And sometimes, Oracle's optimizer ignores the hints. That's why
they're called "hints", instead of "directives", I suppose.

jed
-- 
I wouldn't even think about bribing a rottweiler with a steak that
didn't weigh more than I do. -- Jason Earl