title: Need help on indexing using SQL server 2005
body: <p>I have a table, <code>paymentdetails</code>, with a column <code>paymentstatus</code> (has a check constraint restricting values to either paid or pending). Also, a table <code>patientdetails</code>, that holds patientid, address......columns</p>
  
  <p>I want to create an index that speeds up the execution of extracting the patient details for each patient whose initial payment is pending.</p>