June 26, 2023 at 12:00 am
Comments posted to this topic are about the item SQL Server Resumable Index Operations
June 26, 2023 at 3:07 pm
Can you add the resumable part to a current index? Or do you have to add this once you create the index from the beginning?
June 27, 2023 at 7:40 am
recreate the index with resumable option ON .
June 27, 2023 at 8:21 pm
How often are you reindexing where this feature provides a benefit? We re-index so infrequently. I can't see this providing much of a benefit.
Good article though!
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 29, 2023 at 2:13 pm
Thanks
How large is database and how frequent data is updated/deleted in tables ?
for larger index indexing takes time and this is useful feature in that case
June 29, 2023 at 2:41 pm
Thanks
How large is database and how frequent data is updated/deleted in tables ?
for larger index indexing takes time and this is useful feature in that case
Well, like I said, we do not reindex very often regardless of the size of the table/index. There is one table that's part of a highly transactional system that needs to be reindexed regularly or else the clustered index grows significantly, But, without looking in my log tables, it's been months were any other reindexing occurred.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply