Support of OUTER JOIN in Ingres 10 OpenSQL SELECT statements should enable you to write cleaner code and improve query execution time compared to queries that retrieve the same data without using OUTER JOIN.