Description
As reported in the forum in this post, index is not picked up for IN operator when there is a join.
CREATE INDEX providerIdx ON `deploy-dev`.game.data(data.en.provider.id:string);
|
|
SELECT col_doc.data.en, col_sort
|
FROM `deploy-dev`.game.data col_doc INNER JOIN `deploy-dev`.game_sort.data col_sort ON col_doc.id = col_sort.id
|
WHERE (col_doc.data.en.provider.id IN [ "rls_0ea0a93e-bf2d-4788-9005-83264286d9a5", "rls_b2a9c1b2-8129-48c5-b04e-ad6f809a45a2"]);
|