delete statement

Last Post 03 Apr 2009 09:45 AM by sql-tips. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sql-tips
New Member
New Member

--
31 Mar 2009 11:43 AM
My delete statement takes about 1hour, it has 90M records. What I have to do to improve the speed.
sql-tips
New Member
New Member

--
01 Apr 2009 12:42 PM
Thanks guys giving an idea. Some times I may have to delete based on condition and some times entire records. If you can, Please provide some samples of creating smaller batches and partition tables. I will also research on BOL.
sql-tips
New Member
New Member

--
02 Apr 2009 08:29 AM
This code works fine in SQL2005, but throws error in SQL2000. Incorrect syntax near the keyword 'top'. I am trying for generic code which works for SQL2000,SQL2005 and SYBASE 12.5.4
sql-tips
New Member
New Member

--
03 Apr 2009 09:45 AM
That is fine for now. Thank you for your help. Anyways, we have to go for SQL2005/SQL2008 eventually.
You are not authorized to post a reply.

Acceptable Use Policy