TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Ravi Shekhar
360
4.5k
2.1m
Take very much time at the time of deletion by query
Jul 10 2013 2:51 AM
Hi all,
I have a table which contain 60 colums and appropriate clustered and non clustered index and 50 lacs data. Now i want to move some useless data into any other table. when i insert in other table it takes 5 to 7 minuts per 10 lacs data. now when in delete this data from main table it takes around 40 or more than 40 minuts. Please advice me how to reduce this.
urgent for me.
I am deleting data according to date means datewise.
Please help.
Reply
Answers (
38
)
error occured during database restore
Two nonclusterd index creates any performance issue or not