A clustering index is created when ______.

Explanation

Clustered index determines the order in which the rows of a table are stored on disk. If a table has a clustered index. Then the rows of that table will be stored on disk in the same exact order as the clustered index. In some cases, the index is created on non-primary key columns which may not be unique for each record. Clustering index is defined as an ordered data files.