Re: a hints question

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 28 Jun 1999 10:36:36 +0100
Message-ID: <930562878.16818.0.nnrp-06.9e984b29@news.demon.co.uk>

It's because you are not supposed to qualify table names in hints, so the hint is interpreted as a comment, not a hint.

In the non-owner version of the code, give the qualified table an alias, and use the alias in the hint:

select --+full(XYZ)
from trischbp.blz_t_sic XYZ
where blz='1'

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Tony Adolph wrote in message <7l7eck$c9h$1_at_nnrp1.deja.com>...
>Hello All,
>
>Could someone please explain why the hint used in the following text
>only works when connected to the table's schema and not otherwise:
>
>select --+full(trischbp.blz_t_sic)
>from trischbp.blz_t_sic
>where blz='1'
>
> SELECT STATEMENT, COST=0, CARDINALITY=0
> TABLE ACCESS BY ROWID BLZ_T_SIC, COST=0, CARDINALITY=0
> INDEX RANGE SCAN I_BLZ_T_SIC_IND, COST=0, CARDINALITY=0
Received on Mon Jun 28 1999 - 04:36:36 CDT