title: Sql composite index on 2 datetime fields
body: <p>I have a table called: BookedCars which has StartDate, EndDate and CustomerId as columns.</p>
  
  <p>The query that needs to be super performant just selects all the bookedcars and takes into account STartDate and EndDate aswell as customerId.</p>
  
  <pre><code>Select * from BookedCars where GetDate() between StartDate and EndDate and CustomerId = 3
  </code></pre>
  
  <p>Kinda like this.</p>
  
  <p>Would it be okay from a performance point of view to create a CLUSTERERED composite ( yes clustered) primary key index on StartDate,EndDate and then customerId in that order.So it would be composed out of those 3 columns.</p>
  
  <p>I understand the order matters, is my order ok?</p>
  
  <p>I am using SQL SERVER 2016.</p>
  
  <p>I have several mil rows thats why i need to make it as fast as possible.</p>
  
  <p>thank you.</p>