现代社会科技的发展日新月异.doc

《现代社会科技的发展日新月异.doc》由会员分享，可在线阅读，更多相关《现代社会科技的发展日新月异.doc（3页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、如有侵权，请联系网站删除，仅供学习与交流现代社会科技的发展日新月异【精品文档】第 3 页现代社会科技的发展日新月异,各行各业都开始应用计算机管理软件提升工作效率。数据库的设计是各个管理软件的设计与实现中必不可少的,很多领域都有数据库信息存储与信息处理的技术应用。Oracle数据库是当前比较流行的数据库,SQL作为通用的、功能极强的通用数据库语言如果得到更好的优化,将使软件性能更加优化。数据库性能问题一直是决策者及技术人员共同关注的焦点,影响数据库性能的一个重要因素就是SQL查询语句的低效率。对于SQL语句优化，因为会有成千上万条SQL语句访问Oracle数据库，所以这是最费时间的调整操作。所谓

2、的SQL语句优化就是选择最有效的执行计划来执行SQL语句的过程。本文对Oracle中SQL的优化原理进行了分析。主要从对于Oracle数据库SQL查询优化的重要性着手,从索引以及查询语句等优化方式进行分析,并且总结了一些Oracle数据库SQL查询优化技巧。The development of modern social science and technology change rapidly, all walks of life are beginning to use computer management software to enhance work efficiency. The

3、 database is essential for the design of the design and implementation of each of the management software, many areas have technical application of database information storage and information processing. The Oracle database is currently more popular database, general database language SQL as a comm

4、on, highly functional if get better optimization, will make the software more optimized performance. Database performance problem has been the focus of the decision makers and technical personnel, low efficiency is one of the important factors affecting the database performance is the SQL query stat

5、ement. For the SQL statement optimization, because there will be tens of thousands of SQL statements to access Oracle database, so this is the most time consuming operation adjustment. Process of SQL statement optimization called is to choose the most efficient execution plan to execute the SQL statement.The optimization principle of Oracle in SQL was analyzed. Mainly from the Oracle database SQL query optimization to the significance, carries on the analysis from the indexing and query optimization method, and summarized some Oracle database SQL query optimization techniques.