title: Execution time after adding indexes
body: <p>Indexes increase data access performance. I tried creating indexes but there was no difference in the time cosumption. Am i missing something here?</p>
  
  <p>My schema looks like this. (49 Columns). Id - PrimaryKey (Clustered Index) </p>
  
  <pre><code>Id | Name | Age | CountryId | CourseId | ....... | EnrolledOn
  </code></pre>
  
  <p>There are around 425,000 records in the table. Considering country and course are the columns used to filter the records, I created a composite index comprising these two columns (These two columns are foreign keys).</p>
  
  <p>I tried the following query.</p>
  
  <pre><code>Select * From Students Where CountryId = 1 And CourseId = 1
  </code></pre>
  
  <p>Without indexes and with indexes the query took 11 seconds. </p>
  
  <blockquote>
    <p>Note : Around 415,000 records match the above condition. Will this be a reason for no difference in the time consumed.</p>
  </blockquote>
  
  <p>Can anyone help me on this.</p>
  
  <pre><code>CREATE NONCLUSTERED INDEX IX_Country_Course ON Students(CountryId,CourseId)
  </code></pre>