SELECT
"T0"."FID" "ID",
"T0"."FBIZDATE" "BIZDATE",
"T0"."FHANDLERID" "T1.ID",
"T1"."FNUMBER" "T1.NUMBER",
"T1"."FNAME_L2" "T1.NAME", "T1"."FNAME_L1" "T1.NAME_L1",
"T1"."FNAME_L2" "T1.NAME_L2", "T1"."FNAME_L3" "T1.NAME_L3",
"T0"."FDESCRIPTION" "DESCRIPTION",
"T0"."FASSGRPID" "T2.ID",
"T2"."FLONGNAMEGROUP_L2" "T2.LONGNAMEGROUP",
"T2"."FLONGNAMEGROUP_L1" "T2.LONGNAMEGROUP_L1",
"T2"."FLONGNAMEGROUP_L2" "T2.LONGNAMEGROUP_L2",
"T2"."FLONGNAMEGROUP_L3" "T2.LONGNAMEGROUP_L3",
"T2"."FASSTACCOUNTID" "T3.ID",
"T0"."FSEQ" "SEQ",
"T0"."FORIGINALAMOUNT" "ORIGINALAMOUNT",
"T0"."FLOCALAMOUNT" "LOCALAMOUNT",
"T0"."FREPORTINGAMOUNT" "REPORTINGAMOUNT",
"T0"."FQUANTITY" "QUANTITY",
"T0"."FISFULLPROP" "ISFULLPROP",
"T0"."FSETTLEMENTTYPEID""T4.ID",
"T4"."FNAME_L2" "T4.NAME",
"T4"."FNAME_L1" "T4.NAME_L1",
"T4"."FNAME_L2" "T4.NAME_L2",
"T4"."FNAME_L3" "T4.NAME_L3",
"T0"."FSETTLEMENTCODE" "SETTLEMENTCODE",
"T0"."FSTANDARDQUANTITY" "STANDARDQUANTITY",
"T0"."FBIZNUMBER" "BIZNUMBER",
"T0"."FENDDATE" "ENDDATE",
"T0"."FCUSTOMERID" "T5.ID",
"T5"."FNAME_L2" "T5.NAME",
"T5"."FNAME_L1" "T5.NAME_L1",
"T5"."FNAME_L2" "T5.NAME_L2",
"T5"."FNAME_L3" "T5.NAME_L3",
"T5"."FNUMBER" "T5.NUMBER",
"T0"."FSUPPLIERID" "T6.ID",
"T6"."FNAME_L2" "T6.NAME",
"T6"."FNAME_L1" "T6.NAME_L1",
"T6"."FNAME_L2" "T6.NAME_L2",
"T6"."FNAME_L3" "T6.NAME_L3",
"T6"."FNUMBER" "T6.NUMBER",
"T0"."FORGUNITID" "T7.ID",
"T7"."FNAME_L2" "T7.NAME",
"T7"."FNAME_L1""T7.NAME_L1",
"T7"."FNAME_L2" "T7.NAME_L2",
"T7"."FNAME_L3" "T7.NAME_L3",
"T7"."FNUMBER" "T7.NUMBER",
"T0"."FMATERIALID" "T8.ID",
"T8"."FNAME_L2" "T8.NAME",
"T8"."FNAME_L1" "T8.NAME_L1",
"T8"."FNAME_L2" "T8.NAME_L2",
"T8"."FNAME_L3" "T8.NAME_L3",
"T8"."FNUMBER" "T8.NUMBER",
"T0"."FVERIFIEDCUSSENTID" "T9.ID",
"T0"."FREQCHECKSTATUS" "REQCHECKSTATUS",
"T0"."FTICKETNUMBER" "TICKETNUMBER",
"T0"."FINVOICENUMBER" "INVOICENUMBER",
"T0"."FMACTRLAMOUNT" "MACTRLAMOUNT",
"T0"."FPRICE" "PRICE",
"T0"."FMEASUREUNITID" "T10.ID",
"T10"."FNAME_L2" "T10.NAME",
"T10"."FNAME_L1" "T10.NAME_L1",
"T10"."FNAME_L2" "T10.NAME_L2",
"T10"."FNAME_L3" "T10.NAME_L3",
"T10"."FNUMBER" "T10.NUMBER",
"T10"."FCOEFFICIENT" "T10.COEFFICIENT",
"T10"."FISDISABLED" "T10.ISDISABLED",
"T10"."FGROUPID" "T11.ID",
"T0"."FMAHOLDAMOUNT""MAHOLDAMOUNT",
"T0"."FFEETYPE" "FEETYPE",
"T0"."FASSISTPRICE" "ASSISTPRICE",
"T0"."FASSISTQTY" "ASSISTQTY",
"T0"."FASSISTUNIT""T12.ID",
"T12"."FNAME_L2" "T12.NAME",
"T12"."FNAME_L1" "T12.NAME_L1",
"T12"."FNAME_L2" "T12.NAME_L2",
"T12"."FNAME_L3" "T12.NAME_L3",
"T0"."FENTRYID" "T13.ID",
"T13"."FBILLID" "T14.ID"
FROM
"T_GL_VOUCHERASSISTRECORD" "T0"
LEFT OUTER JOIN "T_PM_USER" "T1" ON "T0"."FHANDLERID" = "T1"."FID"
LEFT OUTER JOIN "T_BD_ASSISTANTHG" "T2" ON "T0"."FASSGRPID" = "T2"."FID"
LEFT OUTER JOIN "T_BD_SETTLEMENTTYPE" "T4" ON "T0"."FSETTLEMENTTYPEID" = "T4"."FID"
LEFT OUTER JOIN "T_BD_CUSTOMER" "T5" ON "T0"."FCUSTOMERID" = "T5"."FID"
LEFT OUTER JOIN "T_BD_SUPPLIER" "T6" ON "T0"."FSUPPLIERID" = "T6"."FID"
LEFT OUTER JOIN "T_ORG_COMPANY" "T7" ON "T0"."FORGUNITID" = "T7"."FID"
LEFT OUTER JOIN "T_BD_MATERIAL" "T8" ON "T0"."FMATERIALID" = "T8"."FID"
LEFT OUTER JOIN "T_BD_MEASUREUNIT" "T10" ON "T0"."FMEASUREUNITID" = "T10"."FID"
LEFT OUTER JOIN "T_BD_MEASUREUNIT" "T12" ON "T0"."FASSISTUNIT" = "T12"."FID"
INNER JOIN "T_GL_VOUCHERENTRY" "T13" ON "T0"."FENTRYID" = "T13"."FID"
WHERE "T13"."FBILLID" = ?
ORDER BY "T13.ID" ASC, "T0"."FSEQ" ASC以上脚本在两个库里面执行的执行计划分别如下
SELECT STATEMENT, GOAL = ALL_ROWS 51988 7 63119
SORT ORDER BY 51988 7 63119
NESTED LOOPS OUTER 51987 7 63119
HASH JOIN 51986 7 62783
INDEX RANGE SCAN CANGO8 IX_GL_VCHENTRYFQ 2 4 232
VIEW SYS 51981 483046 4304422906
HASH JOIN RIGHT OUTER 51981 483046 4083670884
TABLE ACCESS FULL CANGO8 T_BD_MEASUREUNIT 4 17 1462
VIEW SYS 51973 483046 4042128928
NESTED LOOPS OUTER 51973 483046 3587099596
VIEW SYS 51972 483046 3426728324
NESTED LOOPS OUTER 51972 483046 3051884628
VIEW SYS 51971 483046 2811327720
NESTED LOOPS OUTER 51971 483046 2345671376
VIEW SYS 51970 483046 2195927116
NESTED LOOPS OUTER 51970 483046 1717711576
VIEW SYS 51969 483046 1580526512
NESTED LOOPS OUTER 51969 483046 1496959554
VIEW SYS 51968 483046 1403731676
HASH JOIN RIGHT OUTER 51968 483046 1036616716
TABLE ACCESS FULL CANGO8 T_BD_ASSISTANTHG 1740 53952 9171840
VIEW SYS 4346 483046 954498896
NESTED LOOPS OUTER 4346 483046 134769834
TABLE ACCESS FULL CANGO8 T_GL_VOUCHERASSISTRECORD 4345 483046 102405752
TABLE ACCESS BY INDEX ROWID CANGO8 T_PM_USER 1 1 67
INDEX UNIQUE SCAN CANGO8 PK_PM_USER 1 1
TABLE ACCESS BY INDEX ROWID CANGO8 T_BD_SETTLEMENTTYPE 1 1 193
INDEX UNIQUE SCAN CANGO8 PK_BD_SETTLETYPE 1 1
TABLE ACCESS BY INDEX ROWID CANGO8 T_BD_CUSTOMER 1 1 284
INDEX UNIQUE SCAN CANGO8 PK_CUSTOMER 1 1
TABLE ACCESS BY INDEX ROWID CANGO8 T_BD_SUPPLIER 1 1 310
INDEX UNIQUE SCAN CANGO8 PK_BD_SUPPLIER 1 1
TABLE ACCESS BY INDEX ROWID CANGO8 T_ORG_COMPANY 1 1 498
INDEX UNIQUE SCAN CANGO8 PK_ORG_COMPANY 1 1
TABLE ACCESS BY INDEX ROWID CANGO8 T_BD_MATERIAL 1 1 332
INDEX UNIQUE SCAN CANGO8 PK_MATERIAL 1 1
TABLE ACCESS BY INDEX ROWID CANGO8 T_BD_MEASUREUNIT 1 1 48
INDEX UNIQUE SCAN CANGO8 PK_MEASUREUNIT 1 1
另外一个库执行的执行计划
SELECT STATEMENT, GOAL = ALL_ROWS 18 7 19334
SORT ORDER BY 18 7 19334
NESTED LOOPS OUTER 17 7 19334
NESTED LOOPS OUTER 16 7 17871
NESTED LOOPS OUTER 15 7 16674
NESTED LOOPS OUTER 12 7 13370
NESTED LOOPS OUTER 11 7 11361
NESTED LOOPS OUTER 10 7 9184
NESTED LOOPS OUTER 9 7 7203
NESTED LOOPS OUTER 8 7 6727
NESTED LOOPS OUTER 7 7 3248
NESTED LOOPS 6 7 1897
INDEX RANGE SCAN KDNEW IX_GL_VCHENTRYFQ 2 4 232
TABLE ACCESS BY INDEX ROWID KDNEW T_GL_VOUCHERASSISTRECORD 1 2 426
INDEX RANGE SCAN KDNEW IX_GL_VCHASSREC_1 1 2
TABLE ACCESS BY INDEX ROWID KDNEW T_BD_SETTLEMENTTYPE 1 1 193
INDEX UNIQUE SCAN KDNEW PK_BD_SETTLETYPE 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_ORG_COMPANY 1 1 497
INDEX UNIQUE SCAN KDNEW PK_ORG_COMPANY 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_PM_USER 1 1 68
INDEX UNIQUE SCAN KDNEW PK_PM_USER 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_BD_MATERIAL 1 1 283
INDEX UNIQUE SCAN KDNEW PK_MATERIAL 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_BD_SUPPLIER 1 1 311
INDEX UNIQUE SCAN KDNEW PK_BD_SUPPLIER 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_BD_CUSTOMER 1 1 287
INDEX UNIQUE SCAN KDNEW PK_CUSTOMER 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_BD_ASSISTANTHG 1 1 472
INDEX UNIQUE SCAN KDNEW PK_BD_ASSISTANTHG 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_BD_MEASUREUNIT 1 1 171
INDEX UNIQUE SCAN KDNEW PK_MEASUREUNIT 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_BD_MEASUREUNIT 1 1 209
INDEX UNIQUE SCAN KDNEW PK_MEASUREUNIT 1 1
两个库的索引
CANGO8 IX_GL_VCHAACCT Normal FACCOUNTID
CANGO8 IX_GL_VCHENTRYFQ Normal FBILLID, FACCOUNTID, FCURRENCYID, FID, FSEQ, FENTRYDC
CANGO8 IX_GL_VCHENTRY_1 Normal FBILLID
CANGO8 IX_GL_VCHENTRY_2 Normal FACCOUNTID, FCURRENCYID, FSEQ, FISVERIFY
CANGO8 IX_GL_VCHENT_CB Normal FID, FCURRENCYID, FACCOUNTID, FBILLID, FENTRYDC
CANGO8 IX_GL_VE_ACCTCURR Normal FACCOUNTID, FCURRENCYID
CANGO8 IX_GL_VE_DESC Normal FDESCRIPTION
CANGO8 PK_GL_VCHENTRY Unique FID
另外一个
KDNEW IX_GL_VAR_ASSGRP Normal FASSGRPID
KDNEW IX_GL_VAR_BILLID Normal FBILLID
KDNEW IX_GL_VCHASSREC_1 Normal FENTRYID, FSEQ
KDNEW IX_GL_VCHASSREC_2 Normal FID
KDNEW IX_GL_VCHASSTRDCN Normal FCHECKNUMBER
KDNEW IX_GL_VCHASSTRDFQ Normal FENTRYID, FID, FSEQ
KDNEW IX_GL_VCHASSTRDVER Normal FVERIFIEDCUSSENTID
"T0"."FID" "ID",
"T0"."FBIZDATE" "BIZDATE",
"T0"."FHANDLERID" "T1.ID",
"T1"."FNUMBER" "T1.NUMBER",
"T1"."FNAME_L2" "T1.NAME", "T1"."FNAME_L1" "T1.NAME_L1",
"T1"."FNAME_L2" "T1.NAME_L2", "T1"."FNAME_L3" "T1.NAME_L3",
"T0"."FDESCRIPTION" "DESCRIPTION",
"T0"."FASSGRPID" "T2.ID",
"T2"."FLONGNAMEGROUP_L2" "T2.LONGNAMEGROUP",
"T2"."FLONGNAMEGROUP_L1" "T2.LONGNAMEGROUP_L1",
"T2"."FLONGNAMEGROUP_L2" "T2.LONGNAMEGROUP_L2",
"T2"."FLONGNAMEGROUP_L3" "T2.LONGNAMEGROUP_L3",
"T2"."FASSTACCOUNTID" "T3.ID",
"T0"."FSEQ" "SEQ",
"T0"."FORIGINALAMOUNT" "ORIGINALAMOUNT",
"T0"."FLOCALAMOUNT" "LOCALAMOUNT",
"T0"."FREPORTINGAMOUNT" "REPORTINGAMOUNT",
"T0"."FQUANTITY" "QUANTITY",
"T0"."FISFULLPROP" "ISFULLPROP",
"T0"."FSETTLEMENTTYPEID""T4.ID",
"T4"."FNAME_L2" "T4.NAME",
"T4"."FNAME_L1" "T4.NAME_L1",
"T4"."FNAME_L2" "T4.NAME_L2",
"T4"."FNAME_L3" "T4.NAME_L3",
"T0"."FSETTLEMENTCODE" "SETTLEMENTCODE",
"T0"."FSTANDARDQUANTITY" "STANDARDQUANTITY",
"T0"."FBIZNUMBER" "BIZNUMBER",
"T0"."FENDDATE" "ENDDATE",
"T0"."FCUSTOMERID" "T5.ID",
"T5"."FNAME_L2" "T5.NAME",
"T5"."FNAME_L1" "T5.NAME_L1",
"T5"."FNAME_L2" "T5.NAME_L2",
"T5"."FNAME_L3" "T5.NAME_L3",
"T5"."FNUMBER" "T5.NUMBER",
"T0"."FSUPPLIERID" "T6.ID",
"T6"."FNAME_L2" "T6.NAME",
"T6"."FNAME_L1" "T6.NAME_L1",
"T6"."FNAME_L2" "T6.NAME_L2",
"T6"."FNAME_L3" "T6.NAME_L3",
"T6"."FNUMBER" "T6.NUMBER",
"T0"."FORGUNITID" "T7.ID",
"T7"."FNAME_L2" "T7.NAME",
"T7"."FNAME_L1""T7.NAME_L1",
"T7"."FNAME_L2" "T7.NAME_L2",
"T7"."FNAME_L3" "T7.NAME_L3",
"T7"."FNUMBER" "T7.NUMBER",
"T0"."FMATERIALID" "T8.ID",
"T8"."FNAME_L2" "T8.NAME",
"T8"."FNAME_L1" "T8.NAME_L1",
"T8"."FNAME_L2" "T8.NAME_L2",
"T8"."FNAME_L3" "T8.NAME_L3",
"T8"."FNUMBER" "T8.NUMBER",
"T0"."FVERIFIEDCUSSENTID" "T9.ID",
"T0"."FREQCHECKSTATUS" "REQCHECKSTATUS",
"T0"."FTICKETNUMBER" "TICKETNUMBER",
"T0"."FINVOICENUMBER" "INVOICENUMBER",
"T0"."FMACTRLAMOUNT" "MACTRLAMOUNT",
"T0"."FPRICE" "PRICE",
"T0"."FMEASUREUNITID" "T10.ID",
"T10"."FNAME_L2" "T10.NAME",
"T10"."FNAME_L1" "T10.NAME_L1",
"T10"."FNAME_L2" "T10.NAME_L2",
"T10"."FNAME_L3" "T10.NAME_L3",
"T10"."FNUMBER" "T10.NUMBER",
"T10"."FCOEFFICIENT" "T10.COEFFICIENT",
"T10"."FISDISABLED" "T10.ISDISABLED",
"T10"."FGROUPID" "T11.ID",
"T0"."FMAHOLDAMOUNT""MAHOLDAMOUNT",
"T0"."FFEETYPE" "FEETYPE",
"T0"."FASSISTPRICE" "ASSISTPRICE",
"T0"."FASSISTQTY" "ASSISTQTY",
"T0"."FASSISTUNIT""T12.ID",
"T12"."FNAME_L2" "T12.NAME",
"T12"."FNAME_L1" "T12.NAME_L1",
"T12"."FNAME_L2" "T12.NAME_L2",
"T12"."FNAME_L3" "T12.NAME_L3",
"T0"."FENTRYID" "T13.ID",
"T13"."FBILLID" "T14.ID"
FROM
"T_GL_VOUCHERASSISTRECORD" "T0"
LEFT OUTER JOIN "T_PM_USER" "T1" ON "T0"."FHANDLERID" = "T1"."FID"
LEFT OUTER JOIN "T_BD_ASSISTANTHG" "T2" ON "T0"."FASSGRPID" = "T2"."FID"
LEFT OUTER JOIN "T_BD_SETTLEMENTTYPE" "T4" ON "T0"."FSETTLEMENTTYPEID" = "T4"."FID"
LEFT OUTER JOIN "T_BD_CUSTOMER" "T5" ON "T0"."FCUSTOMERID" = "T5"."FID"
LEFT OUTER JOIN "T_BD_SUPPLIER" "T6" ON "T0"."FSUPPLIERID" = "T6"."FID"
LEFT OUTER JOIN "T_ORG_COMPANY" "T7" ON "T0"."FORGUNITID" = "T7"."FID"
LEFT OUTER JOIN "T_BD_MATERIAL" "T8" ON "T0"."FMATERIALID" = "T8"."FID"
LEFT OUTER JOIN "T_BD_MEASUREUNIT" "T10" ON "T0"."FMEASUREUNITID" = "T10"."FID"
LEFT OUTER JOIN "T_BD_MEASUREUNIT" "T12" ON "T0"."FASSISTUNIT" = "T12"."FID"
INNER JOIN "T_GL_VOUCHERENTRY" "T13" ON "T0"."FENTRYID" = "T13"."FID"
WHERE "T13"."FBILLID" = ?
ORDER BY "T13.ID" ASC, "T0"."FSEQ" ASC以上脚本在两个库里面执行的执行计划分别如下
SELECT STATEMENT, GOAL = ALL_ROWS 51988 7 63119
SORT ORDER BY 51988 7 63119
NESTED LOOPS OUTER 51987 7 63119
HASH JOIN 51986 7 62783
INDEX RANGE SCAN CANGO8 IX_GL_VCHENTRYFQ 2 4 232
VIEW SYS 51981 483046 4304422906
HASH JOIN RIGHT OUTER 51981 483046 4083670884
TABLE ACCESS FULL CANGO8 T_BD_MEASUREUNIT 4 17 1462
VIEW SYS 51973 483046 4042128928
NESTED LOOPS OUTER 51973 483046 3587099596
VIEW SYS 51972 483046 3426728324
NESTED LOOPS OUTER 51972 483046 3051884628
VIEW SYS 51971 483046 2811327720
NESTED LOOPS OUTER 51971 483046 2345671376
VIEW SYS 51970 483046 2195927116
NESTED LOOPS OUTER 51970 483046 1717711576
VIEW SYS 51969 483046 1580526512
NESTED LOOPS OUTER 51969 483046 1496959554
VIEW SYS 51968 483046 1403731676
HASH JOIN RIGHT OUTER 51968 483046 1036616716
TABLE ACCESS FULL CANGO8 T_BD_ASSISTANTHG 1740 53952 9171840
VIEW SYS 4346 483046 954498896
NESTED LOOPS OUTER 4346 483046 134769834
TABLE ACCESS FULL CANGO8 T_GL_VOUCHERASSISTRECORD 4345 483046 102405752
TABLE ACCESS BY INDEX ROWID CANGO8 T_PM_USER 1 1 67
INDEX UNIQUE SCAN CANGO8 PK_PM_USER 1 1
TABLE ACCESS BY INDEX ROWID CANGO8 T_BD_SETTLEMENTTYPE 1 1 193
INDEX UNIQUE SCAN CANGO8 PK_BD_SETTLETYPE 1 1
TABLE ACCESS BY INDEX ROWID CANGO8 T_BD_CUSTOMER 1 1 284
INDEX UNIQUE SCAN CANGO8 PK_CUSTOMER 1 1
TABLE ACCESS BY INDEX ROWID CANGO8 T_BD_SUPPLIER 1 1 310
INDEX UNIQUE SCAN CANGO8 PK_BD_SUPPLIER 1 1
TABLE ACCESS BY INDEX ROWID CANGO8 T_ORG_COMPANY 1 1 498
INDEX UNIQUE SCAN CANGO8 PK_ORG_COMPANY 1 1
TABLE ACCESS BY INDEX ROWID CANGO8 T_BD_MATERIAL 1 1 332
INDEX UNIQUE SCAN CANGO8 PK_MATERIAL 1 1
TABLE ACCESS BY INDEX ROWID CANGO8 T_BD_MEASUREUNIT 1 1 48
INDEX UNIQUE SCAN CANGO8 PK_MEASUREUNIT 1 1
另外一个库执行的执行计划
SELECT STATEMENT, GOAL = ALL_ROWS 18 7 19334
SORT ORDER BY 18 7 19334
NESTED LOOPS OUTER 17 7 19334
NESTED LOOPS OUTER 16 7 17871
NESTED LOOPS OUTER 15 7 16674
NESTED LOOPS OUTER 12 7 13370
NESTED LOOPS OUTER 11 7 11361
NESTED LOOPS OUTER 10 7 9184
NESTED LOOPS OUTER 9 7 7203
NESTED LOOPS OUTER 8 7 6727
NESTED LOOPS OUTER 7 7 3248
NESTED LOOPS 6 7 1897
INDEX RANGE SCAN KDNEW IX_GL_VCHENTRYFQ 2 4 232
TABLE ACCESS BY INDEX ROWID KDNEW T_GL_VOUCHERASSISTRECORD 1 2 426
INDEX RANGE SCAN KDNEW IX_GL_VCHASSREC_1 1 2
TABLE ACCESS BY INDEX ROWID KDNEW T_BD_SETTLEMENTTYPE 1 1 193
INDEX UNIQUE SCAN KDNEW PK_BD_SETTLETYPE 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_ORG_COMPANY 1 1 497
INDEX UNIQUE SCAN KDNEW PK_ORG_COMPANY 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_PM_USER 1 1 68
INDEX UNIQUE SCAN KDNEW PK_PM_USER 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_BD_MATERIAL 1 1 283
INDEX UNIQUE SCAN KDNEW PK_MATERIAL 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_BD_SUPPLIER 1 1 311
INDEX UNIQUE SCAN KDNEW PK_BD_SUPPLIER 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_BD_CUSTOMER 1 1 287
INDEX UNIQUE SCAN KDNEW PK_CUSTOMER 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_BD_ASSISTANTHG 1 1 472
INDEX UNIQUE SCAN KDNEW PK_BD_ASSISTANTHG 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_BD_MEASUREUNIT 1 1 171
INDEX UNIQUE SCAN KDNEW PK_MEASUREUNIT 1 1
TABLE ACCESS BY INDEX ROWID KDNEW T_BD_MEASUREUNIT 1 1 209
INDEX UNIQUE SCAN KDNEW PK_MEASUREUNIT 1 1
两个库的索引
CANGO8 IX_GL_VCHAACCT Normal FACCOUNTID
CANGO8 IX_GL_VCHENTRYFQ Normal FBILLID, FACCOUNTID, FCURRENCYID, FID, FSEQ, FENTRYDC
CANGO8 IX_GL_VCHENTRY_1 Normal FBILLID
CANGO8 IX_GL_VCHENTRY_2 Normal FACCOUNTID, FCURRENCYID, FSEQ, FISVERIFY
CANGO8 IX_GL_VCHENT_CB Normal FID, FCURRENCYID, FACCOUNTID, FBILLID, FENTRYDC
CANGO8 IX_GL_VE_ACCTCURR Normal FACCOUNTID, FCURRENCYID
CANGO8 IX_GL_VE_DESC Normal FDESCRIPTION
CANGO8 PK_GL_VCHENTRY Unique FID
另外一个
KDNEW IX_GL_VAR_ASSGRP Normal FASSGRPID
KDNEW IX_GL_VAR_BILLID Normal FBILLID
KDNEW IX_GL_VCHASSREC_1 Normal FENTRYID, FSEQ
KDNEW IX_GL_VCHASSREC_2 Normal FID
KDNEW IX_GL_VCHASSTRDCN Normal FCHECKNUMBER
KDNEW IX_GL_VCHASSTRDFQ Normal FENTRYID, FID, FSEQ
KDNEW IX_GL_VCHASSTRDVER Normal FVERIFIEDCUSSENTID
dbms_stats.gather_table_stats