CODEWITHSUNDEEP
azure-table-storageazure-tablequery
Sam
Sam

Reputation: 30344

Run an Azure Table Storage Query w/o PartitionKey

Is it possible to run a query on an Azure Table Storage table without using the PartitionKey. For example, I'd say, RowKey starts with but do not use the PartitionKey

Two questions:

  1. Is it possible to do this?
  2. Is it a good idea to do this? I'm concerned that even if it is possible, it may have a performance penalty associated with it.

Upvotes: 2

Views: 628

Answers (1)

Sam
Sam

Reputation: 30344

I found the answer to this question.

The short answer is Yes, it is possible to run a query without using the PartitionKey BUT should NOT be used!

A query without partitionKey will do a table scan and is NOT efficient at all. It is important to mention that a query without a partitionKey will perform a table scan even if a rowKey is used in the query.

Here's the Microsoft article that explains all this: https://azure.microsoft.com/en-us/documentation/articles/storage-table-design-guide/

Upvotes: 2

Related Questions