Re: a hints question

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au>
Date: Mon, 28 Jun 1999 20:28:29 +1000
Message-ID: <7l7jfq$jl5$1@m2.c2.telstra-mm.net.au>

Do not put the "owner." in a hint.

Use an alias to put the owner-qualified name there.

HTH --
Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
Is there a nospam domain?
http://www.users.bigpond.net.au/the_Den Tony Adolph <tonyadolph_at_my-deja.com> wrote in message news: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
>
>
> but when connected to trischbp....
>
> select --+full(blz_t_sic)
> from blz_t_sic
> where blz='1'
>
> produces the following explain plan:
> SELECT STATEMENT, COST=48, CARDINALITY=99
> TABLE ACCESS FULL BLZ_T_SIC, COST=48, CARDINALITY=99
>
> Thanks in advance
> Tony
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Jun 28 1999 - 05:28:29 CDT