• kapil_kk (7/22/2013)


    Yes you are right but user PRR asked a scenario only for clustered index and if a clustered index is used then it will reorder of the data in physical order...

    For storage, you are right - the physical storage structure of the data is determined by the clustered index (though not necessarily exactly in the way many people think it is).

    But this question is about the order in which data is returned from a query that does not use ORDER BY. And that order is not related to either the clustered index, the primary key, the insertion order, or the physical storage structure.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/