you should also try to create index on the Join fields and on the Criteria field.