<!-- [if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:PunctuationKerning/>
<w:DrawingGridVerticalSpacing>7.8 磅</w:DrawingGridVerticalSpacing>
<w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery>
<w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:Compatibility>
<w:SpaceForUL/>
<w:BalanceSingleByteDoubleByteWidth/>
<w:DoNotLeaveBackslashAlone/>
<w:ULTrailSpace/>
<w:DoNotExpandShiftReturn/>
<w:AdjustLineHeightInTable/>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:UseFELayout/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!-- [if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
</w:LatentStyles>
</xml><![endif]--><!-- [if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:普通表格;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]-->
To speed up the query the Oracle will choose the materialized view automatically if the parameter take effect.
SQL> create MATERIALIZED VIEW SCOTT.mv1
2
tablespace users
3
BUILD IMMEDIATE
4
REFRESH COMPLETE
5
ENABLE QUERY REWRITE
6
AS select e.ename,d.loc from
scott.emp e,scott.dept d where e.deptno=d.deptno;
实体化视图已创建。
SQL> set autot traceonly explain
SQL> select e.ename,d.loc from scott.emp
e,scott.dept d where e.deptno=d.deptno;
SQL> set lines 345
SQL> /
执行计划
----------------------------------------------------------
Plan hash value: 2958490228
-------------------------------------------------------------------------------------
| Id
| Operation
|
Name | Rows
| Bytes | Cost (%CPU)|
Time
|
-------------------------------------------------------------------------------------
|
0
| SELECT STATEMENT
|
|
14 |
210 |
3
(0)| 00:00:01 |
|
1
|
MAT_VIEW REWRITE ACCESS FULL| MV1
|
14
|
210 |
3
(0)| 00:00:01 |
-------------------------------------------------------------------------------------
Note
-----
-
dynamic sampling used for this statement (level=2)
Close the query rewrite option.
SQL> ALTER SESSION SET
query_rewrite_enabled =false;
会话已更改。
SQL> select e.ename,d.loc from scott.emp
e,scott.dept d where e.deptno=d.deptno;
执行计划
----------------------------------------------------------
Plan hash value: 844388907
----------------------------------------------------------------------------------------
| Id
| Operation
|
Name
| Rows
| Bytes | Cost (%CPU)| Time
|
----------------------------------------------------------------------------------------
|
0
| SELECT STATEMENT
|
|
14 |
280 |
6
(17)| 00:00:01 |
|
1
|
MERGE JOIN
|
|
14 |
280 |
6
(17)| 00:00:01 |
|
2
|
TABLE ACCESS BY INDEX ROWID|
DEPT
|
4 |
44 |
2
(0)| 00:00:01 |
|
3
|
INDEX FULL SCAN
| PK_DEPT |
4 |
|
1
(0)| 00:00:01 |
|*
4
|
SORT JOIN
|
|
14 |
126 |
4
(25)| 00:00:01 |
|
5
|
TABLE ACCESS FULL
| EMP
|
14 |
126 |
3
(0)| 00:00:01 |
----------------------------------------------------------------------------------------
Predicate Information (identified by
operation id):
---------------------------------------------------
4
- access("E"."DEPTNO"="D"."DEPTNO")
filter("E"."DEPTNO"="D"."DEPTNO")
分享到:
相关推荐
For a clustered index, the leaf level is the data itself, so in reality, a clustered index ALWAYS covers any query. Nevertheless, for most of our optimization discussions, we only consider ...
not only on the query optimizer core (Rewrite I, Plan Generator, Rewrite II) of the query compilation process but touch on all issues from parsing to code generation and quality assurance.
Table of Contents Summary of gdb . . . . . . . . ....Free Software ....Free Software Needs Free Documentation ....Contributors to gdb....1 A Sample gdb Session ....2 Getting In and Out of gdb ....2.1 Invoking gdb ....
Querying if the input is valid 14.5.3.2. Getting Invalid, Missing, or Unknown Fields 14.5.3.3. Getting Valid Fields 14.5.4. Using Metacommands to Control Filter or Validator Rules 14.5.4.1. The ...
18 Advanced Query Rewrite 19 Schema Modeling Techniques 20 SQL for Aggregation in Data Warehouses 21 SQL for Analysis and Reporting 22 SQL for Modeling 23 OLAP and Data Mining 24 Advanced Business ...
需要伪静态: # IIS/APACHE Web Server 2 Translated by ONEXIN ...rewrite ^([^\.]*)/(cn|en|tw|jp|kr|de|fr|es|ru|in|pt|ms|bd|ar|vi|th|is|it|gd|id|nl|se|tr|fi|my|ph)(/.*?)?$ $3?lang=$2 last;
2023最新飞机即时通讯系统源码 PC+Android+IOS+WEB四端 ... 数据库imweb、enterprise、databus web 伪静态 code location / { if (!-e $request_filename){...try_files $uri $uri/ /index.php$is_args$query_string; }
如果是//www.jb51.net/p1141.html形式的URL,可通过$_SERVER[‘REQUEST_URI’]和$_SERVER[‘QUERY_STRING’]值的区别来分析,最主要是如果页面是通过重定向会产生$_SERVER[‘REDIRECT_QUERY_STRING’]和$_SERVER[...
<IfModule mod_rewrite.c> RewriteEngine on RewriteBase / RewriteCond %{REQUEST_FILENAME} !-d RewriteCond %{REQUEST_FILENAME} !-f RewriteRule ^(.*)$ index.php?s=/$1 [QSA,PT,L] 3 3. 守护进程管理 ...
59. DwZone Professional Query Manager V1.5.4 For Adobe Dreamweaver 60. DwZone Professional Record Wizard For Adobe Dreamweaver 61. DwZone Site Search Engine V1.2.9 For Adobe Dreamweaver 62. DwZone ...
retrieved and SendMessage is a boolean function (maybe someone has pressed the cancel btn).- Fixed a bug when the subject field is too large.9/2/981.5.1- Fixed a bug with a message within a message ...
# 安装说明 * 1、程序的框架是Laravel 5.8,因此需要环境... * 确保 Apache 启用了 mod_rewrite 模块以支持 .htaccess 解析。 * Nginx 伪静态配置 location / { try_files $uri $uri/ /index.php?$query_string; }
# Don't rewrite any URIs ending with a file extension (ending with .[xxxxx]) RewriteCond %{REQUEST_URI} !\.[a-z]{2,5}$ [NC] # Don't rewrite admin directory RewriteCond %{REQUEST_URI} !^/admin [NC] # ...
将图片自动缩放成指定大小,减少图片体积,从而加快下载速度,降低下载时间和成本。URI 模式 ... http://localhost/images/pic.jpg_50x100m2v2014.jpg QUERY 模式 ... 方式一:50x100 缩放成 50x100 ... Apache mod_rewrite
sql解析利器sqlparser,CLEAN UP MESSY SQL CODES,DETECT SQL SYNTAX ERRORS,RID SQL INJECTIONS,RETRIEVE/REFACTOR TABLE & COLUMN NAME,FIND AFFECTED SQL OBJECTS,Discover the relationship in DDL,QUERY ...
try_files $uri $uri/ /index.php?$query_string ; } 去除末尾的斜杠,SEO更加友好 if (!-d $request_filename) { rewrite ^/(.+)/$ /$1 permanent; } 去除index action if ($request_uri ~* index/?$) { ...
59. DwZone Professional Query Manager V1.5.4 For Adobe Dreamweaver 60. DwZone Professional Record Wizard For Adobe Dreamweaver 61. DwZone Site Search Engine V1.2.9 For Adobe Dreamweaver 62. DwZone ...
59. DwZone Professional Query Manager V1.5.4 For Adobe Dreamweaver 60. DwZone Professional Record Wizard For Adobe Dreamweaver 61. DwZone Site Search Engine V1.2.9 For Adobe Dreamweaver 62. DwZone ...
59. DwZone Professional Query Manager V1.5.4 For Adobe Dreamweaver 60. DwZone Professional Record Wizard For Adobe Dreamweaver 61. DwZone Site Search Engine V1.2.9 For Adobe Dreamweaver 62. DwZone ...
59. DwZone Professional Query Manager V1.5.4 For Adobe Dreamweaver 60. DwZone Professional Record Wizard For Adobe Dreamweaver 61. DwZone Site Search Engine V1.2.9 For Adobe Dreamweaver 62. DwZone ...