首页 | 本学科首页   官方微博 | 高级检索  
     检索      

影响Oracle查询效率的部分因素研究
引用本文:冯亚丽,蔡金武,冯卓利,刘敏勇.影响Oracle查询效率的部分因素研究[J].科学技术与工程,2011,11(14).
作者姓名:冯亚丽  蔡金武  冯卓利  刘敏勇
作者单位:1. 石油大学计算机与信息科学学院,大庆,163318
2. 东北大庆油田有限责任公司天然气分公司,大庆,163411
3. 大庆油田采油分厂,大庆,163411
基金项目:黑龙江省教育厅基金(11552003)资助
摘    要:数据库性能问题一直是决策者和技术人员关注的焦点,而衡量一个系统的性能最直接可靠的判断依据就是数据库的查询响应时间。因此,从数据库查询效率的角度,分析了影响Oracle数据库查询响应时间的部分因素。研究了Oracle数据库的查询优化方法,并针对研究结果进行了充分测试。

关 键 词:Oracle数据库  查询效率  响应时间  

Study of Part Factors which Affects the Searching Efficiency of Oracle
FENG Ya-li,CAI in-wu,FENG Zhuo-li,LIU Min-yong.Study of Part Factors which Affects the Searching Efficiency of Oracle[J].Science Technology and Engineering,2011,11(14).
Authors:FENG Ya-li  CAI in-wu  FENG Zhuo-li  LIU Min-yong
Institution:FENG Ya-li1,CAI Jin-wu1,FENG Zhuo-li2,LIU Min-yong3(Northeast Petroleum University,School of Computer and Information Technology1,Daqing 163318,P.R.China,The Natural Gas System of the Natural Gas Branch Co.or Daqing Oilfied Co.Ltd2,Daqing 163411,Oil Recover Plant No.6 of Daqing Oilfield3,Daqing 16344,P.R.China)
Abstract:The problem of database capability is always the focus concerned by deciders and technician.The most direct and reliable judgement gist to measurement the capability of a system is the response time of the searching time of the database.It thinkes about the searching efficiency of database,analysed part factors which affect the response time of database searching,and studied the optimized methods of Oracle database searching.It also made of a full testing about the study results.
Keywords:oracle database searching efficiency response time  
本文献已被 CNKI 万方数据 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号