Several commonly used SQL optimization statements _ MySQL

Several commonly used SQL optimization statements bitsCN.com

Below are several commonly used SQL statement optimization statements, which are recorded to avoid forgetting.

Although similar data can be obtained through sqlprofiler, it is much easier to use a single query statement.

1. record the query time of the statement

SET STATISTICS TIME ON
GO
SELECT * FROM table
GO
SET STATISTICS TIME OFF
GO

2. record the number of read statements
SET STATISTICS IO ON
GO
SELECT * FROM table
GO
SET STATISTICS IO OFF
GO

3. return the table space size.

Sp_spaceused table

BitsCN.com