Re: Hints in Practice

From: Bob Jones <email_at_me.not>
Date: Fri, 25 Aug 2006 21:30:41 GMT
Message-ID: <5_JHg.18134$o27.12199@newssvr21.news.prodigy.com>

>>
>> The point was that the hints used in the SQL are non-standard, therefore
>> not portable.
>
> So is Oracle's use of NULL. And there is no workaround. So is Oracle's
> security model with roles, and system and object privileges. So is
> Oracle's transaction model. So is Oracle's MVCC. If you make the choice
> to use Oracle ... then embrace Oracle.
>

These are architectural differences. You don't bring all these with you when moving to a different platform.

>>
>> Exactly. Putting hints in the SQL violates all that.
>
> Do reads not blocking writes violate things? How about writes not
> blocking reads? And as pointed out by others here Oracle is not the
> only RDBMS with hints? There is no place to hide. If you don't like
> them ... don't use them. It isn't worth the energy you are putting
> into this.
>

Again, you are missing my point. We are talking about portable code here. Yes, DB2 also has hints, but they do not require the change of SQL. Received on Fri Aug 25 2006 - 16:30:41 CDT