博客首页 → dba

最新文章列表

《Pro Oracle SQL》 10.2.4 Seizing Other Optimization Opportunities

10.2.4 Seizing Other Optimization Opportunities  掌握其他的优化机会     There are other opportunities where subquery factoring may be used to your advantage. If you are working on applications that were ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有982人浏览 2012-07-03 23:31

《Pro Oracle SQL》Chapter10.2.3 Testing the Effects of Query Changes

Testing the Effects of Query Changes    测试查询改变的效果  (page 315)     Even as data does not remain static, SQL is not always static. Sometimes requirements change, so code m ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有973人浏览 2012-06-13 22:59

《Pro Oracle SQL》Chapter 10.2.2 Testing Over Multiple Executions

Testing Over Multiple Executions  测试多个执行   (page 312)     What would happen if each query were run multiple times simultaneously from several different database sessions?  Using a modified version ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有954人浏览 2012-05-24 00:41

《Pro Oracle SQL》Chapter10 -- 10.2 Optimizing SQL -10.2.1Testing Execution Plans

10.2 Optimizing SQL  优化SQL    (page 308)      When a SQL query is designed or modified to take advantage of subquery factoring, there are some not-so-subtle changes that may take place when the ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1326人浏览 2012-05-14 22:19

《Pro Oracle SQL》Chapter 10 Subquery Factoring --10.1 Standard Usage

 Subquery Factoring 子查询分解 (page 305) Jared Still     You may not be familiar with the term subquery factoring .  Prior to the release of Oracle 11gR2, the official Oracle documentation barely ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1139人浏览 2012-05-02 22:46

《Pro Oracle SQL》Chapter 9 -- 9.11 Subquery Factoring

Subquery Factoring    子查询分解     (page 303)     In a business setting, requirements are complex and multiple levels of aggregation are often needed. When writing complex queries, you can often com ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1172人浏览 2012-04-29 23:13

《Pro Oracle SQL》CHAPTER 9 -- 9.10Performance Tuning with the Model Clause

Performance Tuning with the Model Clause  Model子句的性能调优    (page 293)     As with all SQL, sometimes you need to tune statements using the Model clause. To that end, it helps to ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1289人浏览 2012-04-29 16:11

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.9 NULLs

NULLs    (page 291)     In SQL statements using Model SQL, values can be null for two reasons: null values in the existing cells and references to non-existent cells. I will discuss the later sce ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有931人浏览 2012-04-22 19:57

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.8 Lookup Tables

Lookup Tables     查找表 (page 290)     You can define a lookup table and refer to that lookup table in the rules section. Such a lookup table is sometimes termed a  reference table . Reference tabl ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有957人浏览 2012-04-21 14:18

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.7 Iteration

Iteration   迭代  (page 287)     Iteration provides another facility to implementing complex business requirements using a concise Model SQL statement.  A block of rules can be executed in a loop ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1133人浏览 2012-04-21 13:53

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.6 Aggregation

Aggregation   聚合     (page 285)     Data aggregation is commonly used in the data warehouse queries. The Model clause provides the ability to aggregate the data using aggregate functi ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有947人浏览 2012-04-19 01:47

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.5 Evaluation Order

Evaluation Order   求值顺序     (page 282)       Multiple rules can be specified in the rules section, and the rules can be specified with dependencies betweene them. The rule evaluation sequence can a ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1221人浏览 2012-04-17 00:52

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.4Returning Updated Rows

Returning Updated Rows   返回更新的行       (page 280)     In Listing 9-7, just four rows were returned even though there are rows for other weeks. The clause RETURN UPDATED ROWS  controls this behavio ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1274人浏览 2012-04-14 22:36

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.3 Positional and Symbolic Refere

Positional and Symbolic References     位置和符号引用     (page 277)     As discussed previously, the CV function provides the ability to refer to a single cell. It is also possible to refer to an indi ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有965人浏览 2012-04-13 22:01

《Pro Oracle SQL》CHAPTER 9 -- 9.2 Inter-Row Referencing via the Model clause

I nter-Row Referencing via the Model clause 用Model子句行间引用  (page 274)     In a conventional SQL statement, emulating the spreadsheet described in Listing 9-1 is achieved by a multitude of self-j ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1055人浏览 2012-04-10 22:35

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.1 Spreadsheets

The Model Clause    Model子句    (page 273) Riyaj Shamsudeen     The Model clause introduced in the Oracle Database version 10g provides an elegant method to replace the spreadsheet. ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有988人浏览 2012-04-08 15:51

《Pro Oracle SQL》Chapter3 -- 3.3.5 Outer Joins

Outer Joins    外连接      (page 120)      An outer join returns all rows from one table and only those rows from the joined table where the join condition is met.  Oracle uses the  + character ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1283人浏览 2012-04-02 11:41

《Pro Oracle SQL》Chapter 3 -- 3.3.4 Cartesian Joins

Cartesian Joins     笛卡尔连接      (page 118)     Cartesian joins occur when all the rows from one table are joined to all the rows of another table.  Therefore, the total number of rows resulting from ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1038人浏览 2012-04-01 02:14

《Pro Oracle SQL》Chapter 3 -- 3.3.3 Hash Joins

Hash Joins    哈希连接       (page 116)      Hash joins, like sort-merge joins, first reads the two tables to be joined independently and applies the criteria in the WHERE clause.  Based on table and ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1039人浏览 2012-03-30 02:15

oracle logminer 日志分析步骤

1，已dba角色操作 登录 sqlplus /as sysdba: C:\Documents and Settings\Administrator>sqlplus /nolog SQL*Plus: Release 10.2.0.3.0 - Production on Wed Mar 28 00:21:32 201 Copyright (c) 1982, 2006, Oracle.  Al ...
dbalogminer 
nj_apple_tree 评论(0) 有1906人浏览 2012-03-28 00:49

最近博客热门TAG

Java(141747) C(73651) C++(68608) SQL(64571) C#(59609) XML(59133) HTML(59043) JavaScript(54918) .net(54785) Web(54513) 工作(54116) Linux(50906) Oracle(49876) 应用服务器(43288) Spring(40812) 编程(39454) Windows(39381) JSP(37542) MySQL(37268) 数据结构(36423)

博客人气排行榜

    博客电子书下载排行

      >>浏览更多下载

      相关资讯

      相关讨论

      Global site tag (gtag.js) - Google Analytics