MySQL Query Optimization and fine-tune

mart Query optimizer: Developers write My-SQL queries and integrate them into application But Query tuning and create optimal indexes are challenging tasks for them

When we conducted SQL query tuning survey we have observed more than 95% programming developers and 92% My-SQL database administrators create indexes randomly pick columns from where clause without following the B+ tree, full-text indexes rules.

Smart My-SQL come with a new feature called Smart SQL optimizer and it can able to identify slow queries or not indexed queries while writing in query browser and highlight as a warning. Also, the Smart Query Optimizer module can analyze the given query and give optimal indexes and query rewrite recommendations.
Our proprietary algorithm takes dozens of factors under consideration, to eventually recommend the optimal indexes matching your SQL queries.


We have been observed performance improvement up to 100 times query speed after added recommended optimal indexes and Query rewrite recommendations.

The tool can able to identify how much performance has been improved after added new optimal indexes for your query if you create indexes options in the module.

We take the challenge to fix if you face any issues. please send an email with bug details to support at the rate Smart My-SQL dot com. We fix bugs within 2 weeks and release them in new versions.