But do not forget that no_merge will not help if you add predicates on this column: http://orasql.org/2013/06/10/too-many-function-executions/ -- Best regards, Sayan Malakshinov http://orasql.org