数据表索引感化(国外英文资料).docVIP

数据表索引作用 The world of relational databases is a world of tables and collections, tables and collections. 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 the table, the collection of another row and column is obtained. These are abstract concepts, and there is little reference to the basic representation of the database system that is used to manipulate the data in the table. Another abstract concept is that the operations on the table are simultaneous; The query is a conceptual set of operations, and there is no concept of time in the set theory. Of course, the real world is quite different. The database management system implements abstract concepts, but is subject to actual physical constraints within the actual hardware scope. As a result, the query takes time and sometimes takes a long time. And human easily impatient, dont like to wait, so we left a set of those moments of mathematics abstract world to seek to accelerate query method. Fortunately, there are several techniques for accelerating operations that can index tables to make the database server search faster. Consider how to make full use of these indexes to write queries. You can write queries that affect the server scheduling mechanism, enabling queries from multiple clients to collaborate better. We thought about how basic hardware works, in order to figure out how to overcome its physical constraints to improve performance. The goal is to optimize the performance of the database system so that it processes queries as quickly as possible. MySQL is already pretty fast, but even the fastest database can run faster under human design. Well start with indexes because it is the most important tool for speeding up queries. There are other techniques for speeding up the query, but the most efficient way is to use the index properly. On the MySQL mailing list, people often ask questions about making queries faster. I