Jk_rush: summary of some indexes.

Jk_rush is a summary person. This is a good habit. Take the essence of it and go to its dregs. Stand on the shoulders of giants to see it further and gain a deeper understanding. After reading some summaries of jk_rush's blog index, I feel helpful to myself, jk_rush has a deeper understanding of indexes than I do and is worth learning.

Summary of Indexes

If we want to optimize the database, we can optimize the database system using the following five methods.

1. Computer hardware optimization

2. ApplicationProgramOptimization

3. Database INDEX OPTIMIZATION

4. SQL statement Optimization

5. Transaction Processing Optimization

In this blog post, we will want to talk about the index types and application scenarios in databases. This article takes SQL Server as an example and provides reference value for other technical platforms, as long as the correspondingCodeThat's it!

Indexing allows the database engine to perform faster and targeted data retrieval, rather than simply full table scan ).

To use valid indexes, we must have an understanding of the index structure, and we know that adding an index to a data table requires the creation and maintenance of an index table, therefore, we need to globally determine whether adding an index can improve the query performance of the database system.

Http://www.cnblogs.com/rush/archive/2012/04/22/2465683.html

Jk_rush also has some other wonderful blog posts that may be helpful to you. You can select and share the articles that will help you...