Hi Mag, As long as the doc (http://db.apache.org/derby/docs/10.1/ref/rrefjdbc96386.html) says true, you cannot index the CLOB column.
---here is a snippet of the doc------------------------- * Restrictions on BLOB, CLOB, (LOB-types): LOB-types cannot be compared for equality(=) and non-equality(!=, <>. LOB-typed values are not order-able, so <, <=, >, >= tests are not supported. LOB-types cannot be used in indices or as primary key columns. DISTINCT, GROUP BY, ORDER BY clauses are also prohibited on LOB-types. LOB-types cannot be involved in implicit casting as other base-types. -------------------------------------------------------- Regards, Wolfgang. __________________________________ For All Sports Fans! http://pr.mail.yahoo.co.jp/yells/
