1. Shortcut keys
1.1. F8 quick return to current object list
1.2. Ctrl + q to open the query interface
1.3. Ctrl + D quickly modifies the current table structure
1.4. Ctrl + R runs the SQL statement inside the current query interface
1.5. Ctrl + SHIFT + R runs the currently selected SQL statement
2. Quick View of table structure
2.1. Right-click Table information, select object Information
2.2. Right-click Table information, select object information, select DDL information
3. Tools
3.1. Data transfer: It is to copy the data from the inside of a database into another database.
3.2. Data synchronization: As the name implies, to keep the data of two databases in sync
3.3. Structure synchronization: So the name of the matter is to maintain the data structure of two databases consistent
3.4. Copy the current record as an INSERT statement
4. Monitoring function
4.1. Turn on monitoring
4.2. Tick the MySQL database you need to monitor
4.3. Monitor the status of the current server to find the current lengthy SQL statements
5.sql Statement Performance Analysis
5.1. Look at the SQL statement execution time, if the time is too long must be problematic, usually, a SQL statement execution time should be controlled in 0.01 seconds, if greater than this time, then the SQL statement, or the table structure needs to be optimized, as shown in
5.2. Look at the SQL execution plan, that is, this SQL in the execution process, there is no index and so on
5.3. Look at the SQL overview, look at the process of SQL execution, the time-consuming ratio of the various processes
There are, of course, many other ways of optimizing, such as indexing tables, partitioning tables ..., and those who need to be serious about finding answers.
Common features of Navicat Premium