DB Error: The SELECT would examine more than MAX_JOIN_SIZE rows

I get the following error while surfing my site:

DB Error: 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

What might be the best and easy remedy?

Regards
anupent

The reason you see this error is because your query is (apparently) too big. Unfortunately, we cannot change this setting because it helps to protect our servers against queries which will take too much server power.

If you are using a script you wrote yourself, then these answers might help you solve the problem: shared hosting - MySQL MAX_JOIN_SIZE errors - Stack Overflow

If you are using an existing script, the script maintainers will probably be able to help you out.