sqlespresso.com sqlespresso.com

Dropping Unused Indexes on an Azure SQL Database

Index Maintenance is an important aspect of database health. Above and beyond regular index rebuilds and reorganizations it is important to understand the usage of the indexes on your database. Cleaning up unused indexes can save a lot of overhead on Insert/Update/Delete operations. To achieve that goal, I typically run a script like the one shown below and check out whether or not an index has had any seeks or scans against it as a...

programmer group

SQL Server million level database optimization scheme

1. In order to optimize the query, we should try to avoid full table scanning. First, we should consider building indexes on the columns involved in where and order by. 2. Try to avoid null value judgment on the field in the where clause, otherwise the engine will give up using the index and scan the whole table, such as:select id from t where num is null You can set the default value 0 on num to ensure that the num column in the...

programmer group

Technology sharing | InnoDB handler | read * variable interpretation

Author: Gao PengAt the end of the article, there is his book “in-depth understanding of MySQL master-slave principle 32”, in-depth understanding of MySQL master-slave, gtid related technical knowledge.Source version: percona 5.7.14This is a learning record. Please understand if there is any mistake. In this paper, it is recommended to watch on the PC side, with better effect. 1、 The essence of...