What do you understand by Keys and indexes Testing?

1.	What do you understand by Keys and indexes Testing?
Answer» The keys and indexes testing in a database is a form of database testing which ANSWERS the below questions: Have the REQUIRED primary keys and foreign keys constraints been created on the targetted tables? Are the foreign key references valid? Is the data type of the primary key of one table and the corresponding foreign key in the other table the same? Are the naming conventions being followed for all indexes and keys? Are the LENGTHS and sizes of the required indexes and FIELDS expected? Are the indexes clustered or non-clustered working as expected and is according to the business requirements?

Answer»

The keys and indexes testing in a database is a form of database testing which ANSWERS the below questions:

Have the REQUIRED primary keys and foreign keys constraints been created on the targetted tables?
Are the foreign key references valid?
Is the data type of the primary key of one table and the corresponding foreign key in the other table the same?
Are the naming conventions being followed for all indexes and keys?
Are the LENGTHS and sizes of the required indexes and FIELDS expected?
Are the indexes clustered or non-clustered working as expected and is according to the business requirements?

Discussion