You must Sign In to post a response.
  • Category: SQL Server

    Best way to update the tables for more than 20 lacks records

    HI i have 20 lacks records in each 3 tables i want to update one column data in one table value based on 3 tables condition ..

    can any one help me out for best way to update .. when table has 50 lacks of records ..

    performance wise which is the best way to update table
  • #763741
    There are some fundamentals of UPDATE query that you need to take care of,
    -Choose column in WHERE condition having indexes
    - Choose column in WHERE condition having numeric first and then varchar
    - Rebuilding of your clustered index may make your UPDATE query faster

    Thanks
    Koolprasd2003
    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

  • #763765
    Hai Amjad,
    First of all get the record which is going to be updated and then update it.
    So first use the Select statement to get the record/records which will be updated.
    Secondly, you can update these records.
    Hope it will be helpful to you.

    Regards,
    Pawan Awasthi(DNS MVM)
    +91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
    pawansoftit@gmail.com


Sign In to post your comments