home.social

#truncateisexecutedusingtablelock — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #truncateisexecutedusingtablelock, aggregated by home.social.

  1. software dev @[email protected] ·

    truncate vs delete

    it's hard to find a good comparison on the web that covers the details, but also compiled briefly. we have compiled a comparison of these SQL commands, briefly pointing out the most important differences covering the major database engines

    #truncate #delete #sql #oracle #mysql #postgresql #mssql #truncatevsdelete #truncatevsdeleteperformance
    #truncatesql #whytruncateisfasterthandelete
    #truncatetable
    #truncateisexecutedusingtablelock

    details:
    rozwoj-oprogramowania.pl/en/bl

    #truncate #delete #sql #oracle #mysql #postgresql