Creating Join Indexes Using Outer Joins This example examines the EXPLAIN reports for a different outer join-based join index in some detail.