Error "The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay"

Error "The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay"

This error occurs when the database needs to search on more than 1 million rows to meet
he requirements of your query.
This limitation does not concern the number of records in a table,but rather how many records
will be read to satisfy a query, so in a table without proper optimization mysql can make multiple 
​queries to fit the result of a query, addition of indexes, causes mysql to scan fewer records.

- To solve the error in question:
Optimize your query and also create index in your tables, thus increasing the performance of your database.

    • Related Articles

    • How to check your hosting disk space

      The use of your disk space adds up to all files and data in your hosting account, this includes databases, website files, and email accounts. Warning emails will automatically be sent when it is close to reaching 100% of disk capacity. Where to check ...

    • Customize error pages

      First you must access your cPanel: See how to obtain credentials and access cPanel through our article: https://help.scriptcase.net/portal/en/kb/articles/first-steps-with-the-hosting-access  Logged into your cPanel, locate the “Advanced” section and ...

    • How to use the Google Public DNS

      When your connection is bad or awkward, the problem is not found in the Domain Name System (DNS) server. It transforms websites with "beautiful" addresses, such as scriptcase.com, into their respective IP addresses to be read by your ISP. If the ...

    • How to use File Manager and upload a file

      If you don't want to use a 3rd party FTP Software, you can use the cPanel's inbuilt File Manager.       1. Log into your cPanel account.       2. In the "Files" section, click on the "File Manger" Icon.                3. Once in File Manager ...

    • How to select the main PHP version for your hosting service

      Login in your cPanel account and then search for "Software" a category. Click in "Select PHP Versions" icon. By default the selected PHP is the native. You can change it to version which you want. Select the packages which you want to active. Click ...