rebuild locate database

When the index is too fragmented, it affects the speed at which the query is executed, which affects our productivity. The most advantageous measure at this time is to rebuild the index. This article mainly introduces the process of examining index

(1) Check the index that needs to be rebuilt Check in the following areas to determine which indexes need to be rebuilt. First, view the user index in the system table space To avoid fragmentation of the data dictionary, try to avoid the presence

Oracle reconstruction control file-Rebuild controlfile The DBA needs to know when recreating the control file, but it may not be able to reproduce the system throughout his career. First of all, it is emphasized that backup is the safest, quickest,

Information A 1, stop the database server, the database MDF files and LDF files copy backup a copy 2, start the database server, delete the suspect database 3, only with the backup of the database MDF file attached to the database,

Theoretical basisDatabase server is one of the most widely used server types, and many enterprises have to purchase database server in the process of informatization construction. Database server is mainly used for storing, querying and retrieving

1. Database Name 1.1 The Concept Database Name (db_name) is the identifier of a database, just like the ID card number of a person. If multiple databases are installed on a machine, each database has a database name. After the database is installed

Original: You do not know the SQL Server database startup process, and can not start the various problems of analysis and resolution skillsAt present, SQL Server database as a good Microsoft RDBMS, its own start-up time is very few problems, we

Currently, as an excellent RDBMS of Microsoft, SQLServer database has very few problems when it is started. When we use it at ordinary times, we seldom pay attention to the startup process, or you rarely know the underlying running process. Most of

Database Emergency Recovery documentation Revision history DateDate Revision revision version Modify DescriptionChange Description AuthorAuthor 2008-07-06 1.0 Formatting Ultrasql

MySQL Online DDL Improvement and Application, mysqlddlThis article analyzes the implementation principle and precautions of Online DDL. For any DDL operation, the performer must perform a pre-test or clearly understand whether the impact of this