There is also new new hint/optimizer feature - Ansi rearchitecture (hint "ansi_rearch/no_ansi_rearch") -- Best regards, Sayan Malakshinov Oracle performance tuning engineer Oracle ACE Associate http://orasql.org