What is Consistency Check?
A consistency check is performed through the whole database in order to examine if all the tables have index and data pages rightly linked and indexes are properly sorted. Further, a consistency check examines consistency in pointers and information on each page, it also makes sure page offsets are proper. Since it identifies problems thus proves fruitful in mitigation and prevention of problems in the database.
How does Consistency Check work?
The database consistency checker tools are used which provide commands to test the entire database. They analyze physical as well as logical consistency. These tools check page linking and data pointers at row level and page level. Database consistency checker tools store examined results in a “dbccdb” database that administrators can print.
Types and examples:
Using any database consistency tool to check a specific database.