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 ...

    • 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 ...

    • Customize error pages

      First you must access your cPanel: See how to obtain credentials and access cPanel through our article: Here Logged into your cPanel, locate the “Advanced” section and there locate the item “Error pages”; In step 1 you must select the domain you want ...

    • 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 check disk usage

      If you are receiving a disk space usage warning and don't know which folder is using too much space from cPanel.  1. Log into your cPanel account. 2. In the "Files" section, click on "Disk Space Usage" Icon.  3. In Disk Space Usage area you can see ...