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

  • October 29, 2010 at 10:44 am

    #1244333

    mkarthi1982 (10/28/2010)

    Thanks for the Replies.

    I have speed up the performance using Maintenance Plan with Rebuild and Reorganize.

    If you are doing rebuild and reorg on the same tables, PLEASE have a consultant help you out! Hmm, actually have one help you anyway because you shouldn't be using Maintenance Plans for index maintenance!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service