A query was reported that contained multiple outer joins ran very slowly for some values of query criteria. It was observed that the join conditions could allow some of the joins to be converted to inner joins, greatly reducing the number of records to be read. This optimization is now taken when the appropriate join conditions exist.