If you run audit log queries infrequently and the overall performance is important to you , consider running these queries without any indexes or create an index temporarily when you are do audit log analysis 如果您只是偶尔运行审核日志的查询功能，那么整个系统的性能对您来说就是很重要的，当您要进行审核日志分析时，需要考虑在不使用任何索引的情况下运行这些查询功能，或者创建暂时使用的索引。
For detecting - analyzing method based on snapshot difference , we implement these snapshot differential algorithm : sort merge algorithm , partition hash algorithm and window algorithm . for detecting - analyzing method based on log , we discuss the analyzing method of log on two relation database systems - oracle and sql server 对基于快照差分的检测分析方法，我们实现了三种快照差分算法： sortmefge算法、 partitionhash算法和wndow算法；对基于日志的检测分析方法，讨论了oracle和sqlserver两种关系数据库的日志分析方法。
If you plan to run audit log analysis often and you do not want to impact running business processes , consider copying audit log entries into a new table again , using a separate bufferpool or even to a different system , and then create indexes that best match your queries and run these queries on the new table 如果您计划要经常运行审核日志分析，并且您不想影响正在运行的业务流程，您可以考虑将审核日志记录复制到一个新的表格中（当然，也要使用专门的缓冲池） ，或者甚至复制到不同的系统中，然后创建那些能够最好地匹配您的查询功能的索引，并且在新的表格上运行这些查询操作。
