Adding the MySQL Index
As you know, the correct sequence of columns in the composite #MySQL indices is a warrant that EXPLAIN will show full use of the indices, not half, and the sample will be accelerated! The script calculates the selectivity of the columns and makes the correct #SQL request to add the composite index to the correct sharpness based on selectivity. You don’t need to analyze the table and request, count the bytes, perform the GROUP BY for each column, calculating selectivity. Many people don’t understand what selectivity is and why it’s important, adding the indices as it got. We simply select the desired table, look at the slides in the optimized request, and click on their checkboxes - the script automatically calculates selectivity and releases the request to add the composite index with the correct order of the columns. Here we can do it by adding this index, right by the crystal we can drop any index and look at the entire infus on the structure of the selected table and the index. No recharge on Ajax.