informix数据库索引使用与维护（国外英文资料）.doc

informix数据库索引使用与维护（国外英文资料） Use and maintenance of the informix database index. TXT fox is a mountain, you tell me what the serial, standing in your nearest place, looking you smile to others, even if the heart is every pain for your every move. Dazzling white, let me understand what is pure damage. Informix database index usage and maintenance Wang Zengyin For our extensive use of informix database system, it enables us to rapidly and accurately in time management and use of data, and to enable us to speed up the data using the speed and efficiency, the most important thing is to correctly to the database is indexed reasonably. Therefore, the application of the data in the work is more reasonable and more efficient, the database index of informix database is established, the limitation and application scope and the application maintenance and so on are expressed. Add index to the fields in the table can help us fast using the database, but if the table and the index of the improper rather than speed up access to the database, or even cause informix - SQL errors, to suspend the management of the library. Therefore, it is important to understand the scope and limitations of the library table before setting up the library table. In the following situations, it is appropriate to establish a database index: A, which is suitable for finding and continuously exporting large databases, just as the thickening of a dictionary shows the importance of indexing. B, index the connection fields, and when you include many tables in your library, you usually have at least one connection field in the first table, and then index the connection fields. (such as accounting and separate calibration check, the householder account shall be continuous in the head of the household account in a separate account for each to find the effective value, and the head of the household accounts and separate account on the account number field is connected, while using the index than do not use great