A bind term is a condition that connects an outer query and a subquery. If the connecting condition of a subquery is IN and the column to which the subquery is connecting is unique, you can define a join index on the bind term columns. This provides one more type of index for the Optimizer to consider using in place of multiple base tables.