question

Bincy avatar image
Bincy asked

how to get the backend query for my rebuild index maintenance plan

how can i view my backend script for my rebuild index maintenanace plan?
sqlindex
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.

1 Answer

·
raadee avatar image
raadee answered
1. Open the maintenance plan (right click modify) 2. Select your rebuild index task, right click and edit. 3. Click on View T-SQL , then you get the actual script. Why do you want to do this? Just curious or trying to solve a problem?
3 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.

Bincy avatar image Bincy commented ·
Thanks for the response, Please help me to understand what exactly the below options perform while rebuilding. PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF
0 Likes 0 ·
raadee avatar image raadee Bincy commented ·
By the way, have a look at Ola Hallengren Maintenance solution instead of using built in Maintenance Plans. It's way better to use in production. https://ola.hallengren.com/
2 Likes 2 ·
raadee avatar image raadee Bincy commented ·
http://msdn.microsoft.com/en-us/library/ms188388.aspx Check the link, all the options are described there.
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.