Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4991

Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4993
Question 18: Which is most likely the slowest way of emptying a large table? – MySQL Question of the Day

Skip to content

Question 18: Which is most likely the slowest way of emptying a large table?

14. February 2010
By urs in mysql questions

1 Comment

 

a) drop and re-create
b) truncate
c) delete

 
[ Tables and Indexes (15%) - Emptying Tables ]
 

Tags: , ,

Comment Feed

One Response

  1. urs — 14. February 2010 @ 13:22:07 —


    Answer:

    c

    a and b can be much faster, details depend on the storage-engine.
     
     
    A simple question today. Happy Valentine’s Day! <3

You must be logged in to post a comment.