Does View use Indexes Created on Tables

• Asvforce

  SSC Veteran

  Points: 217

  More actions

  February 28, 2006 at 1:43 am

  #90846

  Would a view use the Indexes created on the tables it is using to filter records.

  Consider, i have four tables and every table has 1,00,000 records and each table has a Primary Key with Clustered Indexes on it.

  And my view uses all this four tables using joins. So, in this case would it use the indexes created on that table?

  Thanks and Regards,

  Ashish Patel.

• Ian Yates

  SSCoach

  Points: 19738

  More actions

  February 28, 2006 at 4:52 am

  #623644

  Yes, the view would use indices when joining the tables and evaluating where clauses within the view.