Examples of analysis statements

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 analysis-common analysis statements Summary

Introduction: We sometimes encounter errors or slowdowns in the mysql database. At this time We need to take a look at some basic situations. A bad SQL statement may make your entire program very slow. Is it because there are too many connections? Is there a problem with the table structure? The index of the table is not added? . . Below are some mysql analysis statements that I commonly use, for a record. The function of the serial number statement 1show PROCESSLIST; displays all processes running in the system, that is,

3.

Oracle’s Optimizer (Optimizer) (CBO optimization) Share

Introduction: Before Oracle executes a SQL, it must first analyze the execution plan of the statement, and then execute it according to the execution plan. The work of analyzing the execution plan of the statement is performed by the optimizer (Optimiz

4.

Oracle SQL Statement Analysis Explain Plan

Introduction: EXPLAIN PLAN is a good tool for analyzing SQL statements. It can even analyze statements without executing SQL. Through analysis, we can know how ORACLE

5.

Configure and use the AWR-Format for Chrome plug-in in higher Chrome versions

Introduction: Starting from Chrome version 21, non-Chrome is no longer directly supported Download from the official website, causing AWR-Format to not work properly. According to the description on the Internet: 1. Using -enable-easy-off-store-extension-install does not work. 2. Directly using developer mode to install does not work. The problem cannot be solved. Check the information and Analyze the statement and solve the problem,

6.

Oracle Optimizer

Introduction: 1. Basic knowledge of the optimizer Before Oracle executes a SQL, it must first analyze the execution plan of the statement, and then execute it according to the execution plan. The work of analyzing the execution plan of the statement is completed by the optimizer. A SQL may have different situations. There are multiple execution plans, but at a certain point in time, only one execution plan must be optimal, and it takes time

The above is the detailed content of Examples of analysis statements. For more information, please follow other related articles on the PHP Chinese website!