Storage architecture of Azure Table Storage

Question

Is the data stored within each partition in sequential order i.e. in ascending order of RowKey value?
If yes, then who does this assignment in the servers?
Also, is there any link which describes the entire architecture of how the assignment is done at the backend?

Answer 1

Hi @Sonali Singh8 , welcome to Microsoft Q&A forum.

The primary key for an Azure entity consists of the combined PartitionKey and RowKey properties. The two properties form a single clustered index within the table. The clustered index sorts by the PartitionKey in ascending order and then by RowKey in ascending order. Because a table has only one index, query performance usually is related to the PartitionKey and RowKey properties.

I would suggest you to go through the below article that has detailed information about the same:

Design a scalable partitioning strategy for Azure Table storage

Please let me know if this helps or else we can discuss further.

----------

Please don't forgot to click on accept it as answer button wherever the information provided helps you. This can be beneficial to other community members as well.