• I have a doubt regarding the logical order of rows for Clustered Index.

    Main difference between Clustered and Non-Clustered is Clustered is physical arrangement of rows and Non-Clustered is logical arranging of rows .

    Can you explain a bit more on the arrangement of actual data rows for Clustered and Non-Clustered index.