question

jhunu avatar image
jhunu asked

Is reorganising better then rebuild

Indexing . Is reorganising better then rebuild . Since we cant use Rebuild , we dont want to recreate . And i think re-organise is not recomended after 30% threshold . so how to go for indexing
sql-server-2012
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

4 Answers

·
viikiseth avatar image
viikiseth answered
Rebuid and reorg both are good but it depends on fragmentation of index. Microsoft recommends rebuilding if fragmentation is over 40%, reorganizing if it’s between 5% and 40% and leaving it alone if fragmentation is below 5% and index which are less then 100 Pages .
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ramesh 1 avatar image
ramesh 1 answered
in standard edtion we don't have reorganise
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image WilliamD commented ·
Sorry, but that is not right. Reorganise and rebuild are available in all editions of SQL Server. As @Håkan Winther mentions, online operations are not available in Standard edition
1 Like 1 ·
Håkan Winther avatar image
Håkan Winther answered
Why can't you rebuild, do you mean rebuild online? Do you have a system that need 99% uptime? If that's the case, can you afford not to have enterprise edition?
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jhunu avatar image jhunu commented ·
yes, i cant rebuild .I need rebuild online due to edition .
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
You can rebuild. What you mean is, you can't rebuild when other people are accessing the table/index. If you can't go for Enterprise Edition, then you have to do your index maintenance during a maintenance window (where no-one uses the system).
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
You're going to have to rebuild at some point. Index fragmentation can be a serious performance issue. Ignoring it won't make it go away. You need to find a slow period and schedule the rebuilds. Maybe do only one or two at a time, but you're going to have to do them.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jhunu avatar image jhunu commented ·
Cant it be taken care by Reorganise only
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Nope. That's a logical restructuring only. You need to clean up the physical fragmentation. That's only done by the rebuild.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.