查询处理过程中的优化策略研究

Research on the optimization strategy used when coping with queries

随着业务量的激增,各种行业中数据库的规模逐渐扩大,其结构的复杂性不断加大,与之相关的各类数据库管理系统(DBMS)一定要迅速完善自身的性能,才能更好地满足难度日益增大的信息查询要求。作为解决途径之一,优化策略的选择与落实是十分重要的因素。对各种数据库产品中的优化器在处理查询时所采用的优化策略进行了一定的研究,并结合实例作了进一步阐明。

As business becomes heavier than ever,the record amount and structure complexity of the database used inevery field are also improved.To satisfy the query demands that become more and more intense,something should be done to improve the related DBMS' performance.As one of them,Optimization Strategy's selection and implementation is very important.This article does some research on the strategies used by the famous DBMS' optimizer to cope with queries,and also provides some samples.