I get a missing join predicate warning when I run a simplet single join query with a where clause on the join field. Both tables fields are indexed. Is this a false alarm or is there really something that can be done to fix this. Here is a basic example:
select field1 from table1 t1 inner join table2 t2 on t1.field2 = t2.field2 where t1.field2 = 'myvalue'
It appears to be related to field2 being the join field and the criteria.