Tag Archives: ERROR 1104 (42000): The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

ERROR 1104 (42000): The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

Recently, an error was reported in a large table query as follows: error 1104 (42000): the select would examine more than max_ JOIN_ SIZE rows; check your WHERE and use SET SQL_ BIG_ SELECTS=1 or SET MAX_ JOIN_ SIZE=# if the SELECT is okay

Large table 2.8 million lines. The prompt is very clear

I query show variables like ‘% max’_ JOIN_ Size% ‘is 1 million

After modifying according to the prompt, you can query.