How to Clean up Your wp_options Table and Autoloaded Data

Today we’re going to take a look at the wp_options table in your WordPress database. This is one area which often gets overlooked when it comes to overall WordPress and database performance. Especially on older and large sites, this can be the culprit for slow query times on your site due to autoloaded data that is left behind from third-party plugins and themes. Check out these tips below on how to check, troubleshoot, and clean up your wp_options table. What is the wp_options table?
The wp_options table contains all sorts of data for your WordPress site such as:
Site URL, home URL, admin email, default category, posts per page, time format, etc
Settings for plugins, themes, widgets
Temporarily cached data
The table contains the following fields, one of which we care about more when it comes to performance:
option_id
option_name
option_value
autoload
One of the important things to understand about the wp_options table is the autoload field. This contains a yes or a no value (flag). This essentially controls whether or not it is loaded by the wp_load_alloptions() function. Autoloaded data is data that is loaded on every page of your WordPress site. Just like we showed you how
Source: https://managewp.org/articles/16217/how-to-clean-up-your-wp-options-table-and-autoloaded-data

source https://williechiu40.wordpress.com/2017/10/01/how-to-clean-up-your-wp_options-table-and-autoloaded-data/