Edit : Show what you did. I re-read your previous post about the query running too long. Can you post the execution plan for the above query using substr. Also, in sqlplus, set time on timing on; and then execute the query and post the results using copy paste. You might need to remove the entire resultset.