Hey, It’s quite a well known fact that indexes can be good for your queries. They offer a shorter route to your data, and take some load off your server. They achieve this by creating a Balanced Tree (B-Tree) with pointers to your data. So in a table with customer names, if you search for […]
Woo, 2 in a row! Today I’ll be doing the second part of walking through the Maintenance Plan Wizard, Re-Organizing and Re-Building indexes. Reorganize IndexAgain, does what it says on the tin. This task kicks off an “Alter index REORGANIZE” for all the indexes in your database. It moves around the data in your index
Introduction to the Maintenance Plan Wizard – Part 2 Read More »
