- 博客(14)
- 资源 (99)
- 收藏
- 关注
原创 Improve and Performance Tune your Application Engine Programs
Improve and Performance Tune your Application Engine Programs Writing Efficient App Engine Programsa) Apply Set Processing wherever it
2011-08-08 23:34:12 940
转载 SQL优化34条
我们要做到不但会写SQL,还要做到写出性能优良的SQL,以下为笔者学习、摘录、并汇总部分资料与大家分享! (1) 选择最有效率的表名顺序(只在基于规则的优化器中有效): ORACLE 的解析器按照从右到左的顺序处理FROM子句中的表名,FROM子句中写在最后的表
2011-08-06 15:47:40 480
原创 Sql优化文档
目的数据库参数进行优化所获得的性能提升全部加起来只占数据库应用系统性能提升的40%左右,其余60%的系统性能提升全部来自对应用程序的优化。许多优化专家甚至认为对应用程序的优化可以得到80%的系统性能提升。因此可以肯定,通过优化应用程序来对数据库系统进行优化能获得更大的收益。
2011-08-06 15:46:50 587
转载 ORACLE-SQL优化(2)
Oracle的优化器共有两种的优化方式,即:基于规则的优化方式(Rule-Based Optimization,RBO) 基于代价的优化方式(Cost-Based Optimization,CBO) RBO方式:优化器在分析SQL语句时,所遵循的是Oracl
2011-08-06 15:41:14 640
转载 oracle sql 优化
---------------以下为ORALC 数据库----------------------------- SQL语句优化方法30例在SQL语句优化过程中,我们经常会用到hint,现总结一下在SQL优化过程中常见Oracle HINT的用法:1. /*+ALL_
2011-08-06 15:38:20 609
原创 Getting Information about PeopleSoft Components from Database
Getting fields and records for a page:select OCCURSLEVEL as level, FIELDNUM as taborder, LBLTEXT as label,
2011-08-05 09:57:15 728
转载 Process Scheduler
This wiki page is dedicated to the PeopleSoft process scheduler - the server process(es) that are responsible for running and managing batch
2011-08-04 19:19:25 1195
转载 Application designer tips - Part1
Application designer tips - Part1 Please Sign In or Register to like this blog. Display Control and Related Fields:Always kee
2011-08-04 18:56:09 641
转载 tmunloadcf.exe - PSTUXCFG
tmunloadcf.exe - PSTUXCFG PSTUXCFG - Is there any way to read the binary file PSTUXCFG of PeopleSoft App Server Domain or other. Yes, I
2011-08-04 18:55:20 936
转载 Peoplesoft Foundation tables
Peoplesoft Foundation tables Peoplesoft Foundation tables can be broadly categorized into 1. Organizational tables 2. Persona
2011-08-04 18:54:54 807
转载 How can we use transfer function to skip search page while going from one component to another?
How can we use transfer function to skip search page while going from one component to another? For this we will need to write the pe
2011-08-04 18:54:10 712
转载 Using Push Buttons and Hyperlinks
Using Push Buttons and Hyperlinks I thought I would take the time to write out some of the capabilities of using a Push Button or a Hype
2011-08-04 18:53:20 794
转载 ORACLE JOB
Skip HeadersOracle® Database PL/SQL Packages and Types Reference10g Release 2 (10.2)Part Number B14258-02 Home Book List Content
2011-08-01 13:08:22 870
原创 ORACLE DBA_JOBS 视图
DBA_JOBS All jobs in the database Columns ___________________________ JOB Identifier of job. Neither import/export nor
2011-08-01 11:23:22 2355
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人