title: Clustered index on two columns
body: <p>I've a many-to-many table, let's say:</p>
  
  <pre><code>PersonJob(personId,jobId)
  </code></pre>
  
  <p>with clustered index (personId,jobId).</p>
  
  <p>The question is:</p>
  
  <p>If somewhere in SQL I'll make a query like:</p>
  
  <pre><code>SELECT *
  FROM PersonJob JOIN Job ON PersonJob.jobId = Job.jobId
  .......
  </code></pre>
  
  <p>will it take advantage of that clustered index to find records with particular jobId in PersonJob table ? Or I would be better of creating new non-clusterd non-unique index on jobId column in PersonJob table?</p>
  
  <p>Thanks
  Pawel</p>