Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak
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.
Work details
Budget 23 USD
Added 23 August 2019
320 views
Freelancer
Dmitry Sergeyevich
Ukraine Ukraine  27  0

Very busy Very busy
24 Safes completed
On the service 7 years