The `JOIN` is needed only if `indexBy` is not a PK.. 
But whern `indexBy` is a PK, the query is much simpler... Just a SELECT 1 FROM .. WHERE...

I prefer avoid unnecessary JOIN when possible... especially for large databases