文档介绍：Ⅰ
Ⅰ
Ⅰ
Ⅰ
Ⅰ
Ⅰ
VIIⅠ
<= Ford
> Ford
<= Clark <= Hunt
> Clark > Hunt
Allen 0007 Davis 0002 Green 0006 Jones 0004
Clarke 0003 Ford 0005 Hunt 0008 King 0001
1
2
SELECT "AA001T0"."ACCOUNT_CODE", "AA001T0"."ACCOUNT_NAME" ,
"AA107T0"."DR1", "AA107T0"."DR2" ,
"AA107T0"."CR1", "AA107T0"."CR2" ,
"AA001T0"."CR_DR_GB", "AA001T0"."CR_DR_FLAG"
FROM "AA001T0", "AA107T0"
WHERE ("AA001T0"."ACCOUNT_CODE" = "AA107T0"."ACCOUNT_CODE")
and (("AA107T0"."WORK_YEAR_MONTH" = :r_work_date)
and ("AA107T0"."GB_CODE" = '1')
and ("AA001T0"."TOT_RE_TB_FLAG" = 'Y'))
ORDER BY "AA001T0"."ACCOUNT_CODE" ASC
数据模型执行计划
3
+WORK_YEAR_MONTH+
GB_CODE+… Full scan
=AA107T10.
ACCOUNT_CODE
. MERGE
. .
. .
. . .
. . .
. .
. . x
. .
. ..
.
.
x
x
INDEX
AA107T0
(AA107TO_PK) AA001T10
Array size
TOT_RE_TB_FLAG=‘Y’
4
562行 561行 255行 981行
=AA107T10.
ACCOUNT_CODE
. MERGE
. .
. .
. . .
. . .
. .
. . x
. .
. ..
.
.
x
178行
x
INDEX
AA107T0
(AA107TO_PK) AA001T10
Array size
TOT_RE_TB_FLAG=‘Y’
5