浅谈索引失效原因、对策及其应用

针在银行金融业应用系统中往往涉及大数据量的查询与操作，其中索引对系统的性能起到了至关重要的作用。本文分析了索引的基本概念及数据库内部优化器的工作机制，科学分析了导致索引失效地各种情况，提出了隐式失效、主动失效、累积失效的定义，同时也给出了避免索引失效的各种对策及其在银行第三方存管系统中的实际应用案例，对开发高性能数据库应用有一定的指导意义。

Discussion on the Index Failure Reason,Countermeasure and its Application

In the banking and financial application systems that often involve large amount of data query and operation,the index has played a vital role in the performance of the system.This paper analysis the basic concept of index and the interior of the database optimizer work mechanism,scientific analysis of the cause of failure of various index,put forward the implicit failure,active failure,cumulative failure definition,at the same time it gives various measures to avoid the failure of the index and the real application in the bank third party depository system as a practical application case,provides some guiding significance on the development of high performance database application.