title: Azure cosmos db is faster without partition key
body: <p>I'm confusing about the partition key with cosmos db. I have a database/container with about 4000 small records. If I try a sql statement with my partition key filter, the RUs and the duration time is larger then without. </p>
  
  <p>Does someone understand this?  </p>
  
  <p>in this sample my partition key of the container is /partitionKey</p>
  
  <p>I tried this statement: 
  SELECT * FROM  c where  c.partitionKey = 'userSettings' And c.deleted =false</p>
  
  <p>Request Charge      50 RUs
  Document load time  2.15 ms</p>
  
  <p>and then this 
  SELECT * FROM  c where  c.cosmosEntityName = 'userSettings' And c.deleted =false </p>
  
  <p>Request Charge      5 RUs
  Document load time  0.38 ms</p>
  
  <p>I expect exactly the opposite results.</p>
  
  <p>Here some screenshots:
  <a href="https://i.stack.imgur.com/tVk7D.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tVk7D.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/5sOaX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5sOaX.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/RQimR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RQimR.png" alt="enter image description here"></a></p>