GUI of SQL Server indexes and GUI of statistics

Source: Internet
Author: User
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

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.