Data Manipulation
info
Data manipulation in SQL include DML (Data Manipulation Language) and DQL (Data Query Language) statements, primarily involving operations such as data insertion (INSERT), querying (SELECT), updating (UPDATE), and deletion (DELETE). Improperly written data operation statements may lead to various issues in terms of correctness, security, maintainability, and performance. PawSQL has designed a total of 85 audit rules for data operation statements from these four perspectives.
📄️ Order by Random Optimization
Channel of advanced SQL tuning
📄️ Avoid COUNT DISTINCT on Nullable Multi-Columns
Copyright © 2023 PawSQL
📄️ Avoid Using CROSS JOIN
Copyright © 2023 PawSQL
📄️ Mixed Sort Directions Disable Index Usage
Copyright © 2023 PawSQL
📄️ Avoid Using Natural Join
Copyright © 2023 PawSQL
📄️ Avoid using STRAIGHT_JOIN
Copyright © 2023 PawSQL
📄️ Avoid using LIMIT in UPDATE/DELETE
Copyright © 2023 PawSQL