数据表索引作用（Table index function）.docVIP

数据表索引作用（Table index function） The world of relational databases is a world dominated by tables and sets, tables, and sets. A database is a collection of tables, and tables are collections of rows and columns. When a SELECT query is published to retrieve rows from a table, a collection of other rows and columns is obtained. These are some abstract concepts, which are of little reference value to the basic representation of the database system for manipulating data in tables. Another abstract concept is that all operations on the table are simultaneous; query is a conceptual set of operations, and there is no concept of time in set theory. Of course, the real world is quite different. The database management system implements the abstract concept, but it is subject to actual physical constraints in the actual hardware range. As a result, queries take time and sometimes take a long time. Humans are impatient and impatient to wait, so we leave the abstract world of instantaneous mathematical operations on the set to look for ways to speed up queries. Fortunately, there are several accelerated computing techniques that index tables so that the database server finds rows faster. Consider how you can make full use of these queries to write queries. A query that affects the server scheduling mechanism can be written so that queries from multiple clients can collaborate better. We think about how the basic hardware works to figure out how to overcome its physical constraints and improve performance. The goal is to optimize the performance of the database system so that it can process queries as quickly as possible. MySQL is pretty fast, but even the fastest databases can run faster in peoples designs. We first discuss indexing as it is the most important tool for speeding up queries. There are other techniques for speeding up queries, but the most effective one is the proper use of indexes. On MySQLs mailing list, people usually ask questions about making queries faster. In