| Oracle SQL性能优化之探究 |
| |
| 引用本文： | 王关祥,张焕远,夏亚东,刘瑾,王华兵.Oracle SQL性能优化之探究[J].中国教育技术装备,2012(3):74-76. |
| |
| 作者姓名： | 王关祥 张焕远 夏亚东 刘瑾 王华兵 |
| |
| 作者单位： | 山东农业大大学网络与教育技术部;南京中兴软创公司南京研发中心 |
| |
| 摘 要： | 在数据库应用中,根据用户提交的查询请求,如何才能精炼又高效地得到查询结果?从多个角度描述怎样优化SQL语句。实验结果表明,SQL优化能够减轻系统资源的占用,满足用户的要求。
|
| 关 键 词： | SQL优化 RBO CBO SGA 高效SQL |
Research on Oracle SQL Performance Optimization |
| |
| Wang Guanxiang,Zhang Huanyuan,Xia Yadong,Liu Jin,Wang Huabing.Research on Oracle SQL Performance Optimization[J].china educational technique & equipment,2012(3):74-76. |
| |
| Authors: | Wang Guanxiang Zhang Huanyuan Xia Yadong Liu Jin Wang Huabing |
| |
| Institution: | 1 Department of Network and Education Technology,SDAU,Taian,Shandong,China 2710182 Nanjing R&D Center,ZTEsoft,Nanjing,China 210012 |
| |
| Abstract: | In the database application,how to refining and efficiently get the query result according to user’s query request? This article describes how to optimize the SQL statement with many aspects.The experimental results show that,SQL optimization that can reduce the occupier of system resources,to meet the requirements of the customers. |
| |
| Keywords: | SQL optimization RBO CBO SGA efficient SQL |
| 本文献已被 CNKI 等数据库收录！ |
|
