2_
а если индекс кластерный?
по идее это как раз этот случай, но я всегда order by указываю, чтобы не было роялей в кустах
нашел такое
In SQL Server, the data is stored in the data pages by the order of the clustered index, regardless of which index is defined as the primary key.
If you do not specify a sort order for the clustered index (or any index, for that matter), the order will be ascending, by default.
https://stackoverflow.com/questions/23162781/does-a-primary-clustered-key-default-order-ascending#:~:text=1%20Answer&text=In%20SQL%20Server%2C%20the%20data,will%20be%20ascending%2C%20by%20default.
по идее это как раз этот случай, но я всегда order by указываю, чтобы не было роялей в кустах
нашел такое
In SQL Server, the data is stored in the data pages by the order of the clustered index, regardless of which index is defined as the primary key.
If you do not specify a sort order for the clustered index (or any index, for that matter), the order will be ascending, by default.
https://stackoverflow.com/questions/23162781/does-a-primary-clustered-key-default-order-ascending#:~:text=1%20Answer&text=In%20SQL%20Server%2C%20the%20data,will%20be%20ascending%2C%20by%20default.
