Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    9

    Unanswered: record deletion problem

    In my site 1 tb. is having around 29,00,000 records...can anyone tell me a efficent way to delete all records....
    normal sql takes millions of seconds ..so need some smart way...

  2. #2
    Join Date
    Feb 2005
    Posts
    1
    Truncate table <tablename>

  3. #3
    Join Date
    Oct 2004
    Posts
    9
    ty..
    i got the solution...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •