GUI of SQL Server indexes and GUI of statistics

GUI of SQL Server indexes and GUI of statistics

Preface

Many experts prefer to use tsql statements to set sqlserver.ProgramPersonnel characteristics use various command lines, but I still have many gaps from masters

I personally think that what can be done on the image interface sometimes does not need a graphical interface? The effect of GUI settings is the same as that of tsql statements.

I found out this evening that the graphic interface can also be used to view indexes and set indexes and statistical information. I used to remember so many tsql statements.

Crash. Some simple settings require statements, such as DBCC show_statistics ()

 

The following describes how to do this:

You can see the table name, index name, index type, unique or not, and so on.

Option

I think you will always set the options in the red box below. Please note that the specific functions are not described here.

 

You can also re-generate all the indexes and re-organize all the indexes. You only need to right-click the folder icon of the index, so sqlserver is quite user-friendly.

 Include columns

A clustered index cannot create an inclusive column. Only non-clustered indexes can create an inclusive column.

For the role of the include column, let's take a look at this article.Article: Include charm in SQL Server indexes (include index of included columns)

Storage

Table partition settings

 

Fragment

The red boxes below are also frequently noticed.

 

Extended attributes

 

For the effect of fragmentation, fill factor, re-indexing, and re-organizing indexes in SQL Server indexes, you can refer to Song Daxia's article in the garden:

T-SQL queries fragments and fill factors in advanced-SQL Server Indexes

 Statistics

Sqlserver automatically creates statistics for each index.

 

Details