Description
Give some examples of count being used with an index - where the count is returned by looking only at the index and some where the records have to be checked. Give some explanation that the records must be paged into memory the first time the count is run and this will be slow the first time and subsequent indexes will be faster.