Database is very slow when creating an index
Posted
by
kaliyaperumal M
on Stack Overflow
See other posts from Stack Overflow
or by kaliyaperumal M
Published on 2012-06-21T15:06:47Z
Indexed on
2012/06/21
15:16 UTC
Read the original article
Hit count: 129
sql-server
My database has around 25 core numbers, in that weekly basis I need to create an index and drop index. While creating the index it takes long time to complete, my log file also keeps on increasing, and when I delete some numbers from that table also taking too much time (because weekly basis I have to delete 30 to 50 lack numbers and add 30 to 40 lack new number also).
Can u please give me the proper solution..
© Stack Overflow or respective owner