I had a task to check indexes with high percentage > 30 % and then rebuild it.
I did both operation in MS SQL Studio and wanted to compare values using Toad because I prefer to use it.
I found the place Tools - Administration - Index fragmentation which allowed to search for Fragmentation percentage. This place provide an option to select the type of search like '‘Detailed’ and etc.
I did not know which one to select and tried all 3 available but none of the Result was equal to the one I’ve got using MS Studio. BTW in Studio I used right-button on index - Properties - Fragmentation and read result.
My question: where is the right place to check for index fragmentation in Toad, which parameters to select for search in case I want to see the same output that I have in Studio?