The Tables and Indexes view allows you to see general table and index statistics for the database selected. The Indexes tab displays all indexes defined for the selected table and an overview of each index. This allows you to quickly see how the table is utilized and how it is affected by and affects other tables and objects. The Table Dependencies tab displays the objects the selected table references and is referenced by, the type of dependency, and the action of the dependency. To view the Table Size Details chart, select a table from the list and click the Size tab in the Table Details section. The Table Size Details chart displays the size of each component in a table. It also lists the data distribution data values and occurrences of each value. Lists the number of columns, average length, average row hits, and row hits percentage for each column in an index associated with the selected table. Lists the associated indexes and index information for the selected table. In addition to the object name, the type of object and action associated is listed. Lists other database objects that the selected table contains references to and other database objects that reference the selected table. The following tables are available in the Table Details section: Sizeĭisplays the size of the data, text, and indexes associated with the selected table. To update the statistics for your tables, click Update Statistics at the top of the view. The Table Details section of the Table and Indexes view allows you to view various details on the selected table. To open the Tables & Indexes view of the SQL Diagnostic Manager Databases tab, select the appropriate SQL Server instance, click Databases, and select Tables & Indexes. System tables cannot have indexes rebuilt. The Rebuild Indexes function is enabled for User tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |