what are the best way to query optimization in MYSQLSolution

what are the best way to query optimization in MYSQL.

Solution

The best way to query optimization in MYSQL is as below.

1.INDEXES:It behaves as a pointers to row of a table. MYSQL permits us to index data tables.computing the index to a table is nothing but calling the CREAYTE INDEX command ,defining the feilds to index.nearly 16 indexes is possible for a table. Additionally the MYSQL assiststhe multi column indexes and full text search indexes.

Additionally to query optimization in MYSQL.

1.Optimizing the query perfomance:during the examination of query perfomance,it is in service to review the EXPLAIN keyword. it is kept before a select query ,tells how MYSQL aims to execute the query and rows required to process .

2.Modifying the internal variables: MYSQL is much open and reasonably simple additonally fine-tune its default settings to get high perfomance and stability.