title: Is it possible to query a big Azure Table with specific search parameters but without PartitionKey?
body: <p>Let say I have a table entity as it :</p>
  
  <p>Partitionkey
  Rowkey
  table
  userid
  datecreated</p>
  
  <p>Let's take a query which works great, with it I can retrieve all entries wich have a particular ID (which is used as the PartitionKey)</p>
  
  <pre><code>Dim azt_query As CloudTableQuery(Of adlog)
  azt_query = azt_context.CreateQuery(Of adlog)("adlog").Where(Function(e) (e.PartitionKey = "myid" And e.table = "mytable" And e.userid = "myuserid" And e.datecreated &gt;= dateStart And e.datecreated &lt;= dateEnd)).AsTableServiceQuery()
  </code></pre>
  
  <p>Now I would like to query the table without knowing the PartitionKey but based on the USERID</p>
  
  <p>It would be like that :</p>
  
  <pre><code>Dim azt_query As CloudTableQuery(Of adlog)
  azt_query = azt_context.CreateQuery(Of adlog)("adlog").Where(Function(e) (e.table = "mytable" And e.userid = "myuserid" And e.datecreated &gt;= dateStart And e.datecreated &lt;= dateEnd)).AsTableServiceQuery()
  </code></pre>
  
  <p>But removing the e.PartitionKey = "myid" now it takes forever. I think the query want to retrieve all the rows of the table and search in it with the parameter.</p>
  
  <p>But there is millions of rows. Querying with the partitionkey is actually pretty fast.</p>
  
  <p>Is there a way to query this ?
  Can I retrieve all the rows of a particular USERID or I'm I stuck to the partitionkey level ?</p>