Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Robust unique identifiers?
On 23 Jan 2005 08:47:27 -0800, "Jining Han" <jining.han_at_gmail.com>
wrote:
> Also, if the
>conversion happens elsewhere, NOT in the database, then the use of
>index is still possible.
unfortunately if the hard-coded literal isn't explicitly converted, or the bind variable used is of the correct type the statement will be rewritten as rawtohex(column) = constant
-- Sybrand Bakker, Senior Oracle DBAReceived on Sun Jan 23 2005 - 15:24:23 CST