a hints question

From: Tony Adolph <tonyadolph_at_my-deja.com>
Date: Mon, 28 Jun 1999 09:14:01 GMT
Message-ID: <7l7eck$c9h$1@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 - 04:14:01 CDT