|
|
|
|
|
DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Raise your hand if you have ever tried to manage or even look at your indexes in Enterprise Manager. Keep your hand up if you found this easy and intuitive. Since no one has their hand up at this point, DBArtisan eliminates that headache. No more highlight the table, right click, select manage indexes, and go one table/index at a time through your database. Selecting the indexes item displays a list of all of the indexes in the database, the table they are created on, and whether they are clustered or unique. In short all of the basic information you would want about the indexes in your database.
Double clicking on an index brings up the index editor. The columns tab allows you to add/remove columns from the index. The attributes tab is where you specify unique, nonclustered, or clustered. The storage tab allows you to specify which filegroup the index will be created on. The statistics tab shown below shows all of the available stats concerning the index and storage. The DDL tab will provide a script to recreate the index.
DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
