What is the index? How does Win10 index speed up the query?

What is an index? Indexes are similar to directories, which help us quickly find what we need, and we can quickly access specific information in database tables through indexes. In the Windows operating system, the system has a search function, and the search function is based on the index. If you want to speed up the search, then we have to improve the index query speed. So, how does Win10 index speed up the query? Let's take a look at it.

What is an index?

In a relational database, an index is a storage structure in which a single, physical number sorts the values ​​of one or more columns in a database table. It is a column or columns of values ​​in a table. The collection and corresponding list of logical pointers to the data pages in the table that physically identify these values. The role of the index is equivalent to the catalog of books, you can quickly find the content you need based on the page number in the catalog.

How does Win10 index speed up the query?

1, Win + R open operation, the transport type gpedit.msc, open the Group Policy Editor;

2, the Group Policy Editor window, still expand to & ldquo ; computer configuration - Administrative templates - Windows components - Search & rdquo ;, then you can see in the right pane & ldquo; disable indexer back-off & rdquo; the configuration items;

3, double-click "Disable indexer fallback" configuration item to open the configuration window, we first look at the "Help" in the explanation of the configuration item:

If this policy is enabled, disable the search indexer back Back function. Even if the system is active, the index will continue to run at full speed. If this feature is disabled and the system is active a lot, the fallback logic is used to adjust the indexing activity backwards. This policy is disabled by default.

4, because our purpose is to let the indexer run at full speed at all times, so you can simply launch the strategy. Modified above to “enabled”, OK.

after

5, reboot the system settings to take effect.

What is the index? Do you understand? The index is similar to the catalog in the book, which helps us quickly find what we need. If you want to speed up the search speed of the system, you can disable the indexer rollback according to the method described in the small series, so that the index function of the system is fully fired.