I think would be helpful hint: opt_param('_convert_set_to_join','true') Best regards, Sayan Malakshinov Senior Oracle performance tuning engineer PSBANK http://orasql.org