> example & try then. Note that Oracle can't use indexes in joins for > implicitly or explicitly converted data - unless you have relevand function > based indexes there... So, you might have problem in your design.
Just a little clarification to my own post just in case: The index can not be used in a join for the column that gets converted, either implicitly or explicitly, unless there is a corresponding function based index on the column. But other table in join, which' column isn't converted, can very well be looked up using index if optimizer chooses so. Cheers, Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).