Hi all, We've noticed that some queries with the oracle bundle persistence manager are very slow (an order of magnitude slower than with MSSQL for instance). This seems to be due to an implicit conversion from a raw value to a varchar2 which disables the index (see http://orafaq.com/maillist/oracle-l/2007/02/14/1050.htm).
Would it be possible to use the suggested HEXTORAW function, or does that have unwanted side effects? I.e., use "select BUNDLE_DATA from " + schemaObjectPrefix + "BUNDLE where NODE_ID = HEXTORAW(?)"; Best regards, Martijn -- Martijn Hendriks <GX> creative online development B.V. t: 024 - 3888 261 f: 024 - 3888 621 e: [EMAIL PROTECTED] Wijchenseweg 111 6538 SW Nijmegen http://www.gx.nl/
