iPhone dev Stupidty 111: SQL table order
"In a relational database... rows have no order! This cannot be stressed enough. I don't care how you order the rows, SQL Server is under no obligation to return the data in that order. And frankly, even if you order the data using the clustered techniques mentioned, this only guarantees it when you rebuild it. After that, SQL Server may split pages, and then you technically don't have a flat structure anymore. "
No comments:
Post a Comment