Re: SQL hints: absolute override?

From: Izack Varsanno <izack_v_at_netvision.net.il>
Date: 1997/01/27
Message-ID: <5ciuud$8n1@news.NetVision.net.il>#1/1

dmausner_at_brauntech.com (Dave Mausner) wrote:

>>What happens if the hinted index is not there, or is modified?

>since hints are buried inside comments, they are ignored if they
>are either syntactically or semantically incorrect, without
>warning.

This is true,
The only problem is that even not valid hint force ORACLE to use the cost based optimizer, which can have very bad impact on some situation (table without statistics, ORACLE version 7.1.*, etc...)

Regards,

Izack Varsanno. Received on Mon Jan 27 1997 - 00:00:00 CST