Home Forums SQL Server 2005 T-SQL (SS2K5) To Fetch Records from a table quickly which is having 10 Lakhs record RE: To Fetch Records from a table quickly which is having 10 Lakhs record

  • You can create Indexed view - add Index on the view.

    As per BOL:

    "An indexed view is a view that has been materialized. This means it has been computed and stored. You index a view by creating a unique clustered index on it. Indexed views dramatically improve the performance of some types of queries. Indexed views work best for queries that aggregate many rows."

    Refer: http://msdn.microsoft.com/en-us/library/ms191432.aspx

    Thanks