Database Normalisation Questions
The purpose of non-clustered indexes in database normalization is to improve the performance of queries by allowing for faster data retrieval. Non-clustered indexes are created on columns that are frequently used in search conditions or join operations, and they provide a separate structure that contains a copy of the indexed columns along with a pointer to the actual data. This allows for quicker access to specific data without having to scan the entire table.