Recommended articles about Procedure_Analyse

one. Preface PROCEDURE ANALYSE(), which can be used as an auxiliary reference to analyze statements when optimizing the table structure. Using this statement, MySQL helps you analyze your fields and their actual data, and will give you some useful suggestions. [These suggestions will only become useful if there is actual data in the table, because making some big decisions requires data as a basis. ] For example, if you create an INT field as your primary key, but there is not much data, then PROCEDURE ANALYSE() will recommend that you change the type of this field to MEDIUMINT. Or you're using a VARCHAR field, and since there's not much data, you might get a message asking you to change it to ENUM suggestions. These suggestions are all possible because there is not enough data, so the decision-making is not accurate enough. When we design a table, we sometimes always think about what type to use for a certain field. If you are a novice PHPer, you will have considerable experience and can type it out directly. In fact, we can also use procedure analyze(); analysis during later tuning.

1. Mysql optimization -Procedure_Analyse optimize table structure

##Introduction: 1. Preface PROCEDURE ANALYSE(), which can be used as an auxiliary reference to analyze statements when optimizing the table structure. Using this statement, MySQL helps you analyze your fields and their actual data, and will give you some useful suggestions. [These suggestions will only become useful if there is actual data in the table, because making some big decisions requires data as a basis. ] For example, if you create an INT field as your primary key, but there is not much data, then, PROCEDURE ANAL

2. MySQL uses procedure analyze() Function optimization table structure

Introduction: I don’t know if you have ever encountered what type to choose for the MySQL table structure Field and depressed? Or are you confused about what length to choose for MySQL fields? In the following article, I will introduce to you a martial arts secret that I only learned recently. Friends who are interested can take a look below.

3. Use procedure analyze() to analyze mysql_MySQL

Introduction: procedure analyze(); The syntax is as follows select column from table_name procedure analyze(); The following is a quote from an article: PROCEDURE ANALYSE provides optimization suggestions for each column of the existing table by analyzing the select query results. PROCEDURE ANALYSE's..

The above is the detailed content of Recommended articles about Procedure_Analyse. For more information, please follow other related articles on the PHP Chinese website!