database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
Firebird
Oracle
Informix
ㆍSybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
Sybase Q&A 1889 게시물 읽기
No. 1889
ASIQ 쿼리 플랜정보 확인하기..
작성자
이은영(eunylee)
작성일
2007-04-20 13:42
조회수
6,255

안녕하세요 


질문이 있습니다.


ASIQ 쿼리에 대한 plan정보를 봤는데요..


어떤식으로 해석해야할지


알수가 없어서요..


혹시 그거 관련해서 메뉴얼이 있다면 주셨음 합니다.


아래와 같이 나왔는데...뭐 어떤 정보를 확인할 수 있는건지..


아 그리구 ASIQ는 CPU가 만약 4개가 있는 서버라면...몇개를 사용하라고 따로 지정하는게 있나여??? 

그냥 4개면 4개 다 알아서 쓰나요?


#08 부터 나오는데...어떤거 부터 봐야하는건지요? #01부터 찾아보는거 아닌지여?


2007-04-20 11:21:54 0000009031 [20535]: Query Plan:

2007-04-20 11:21:54 0000009031 [20535]: 0    #08:  Root

2007-04-20 11:21:54 0000009031 [20535]:         Child Node 1:  #07

2007-04-20 11:21:54 0000009031 [20535]:         Estimated Result Rows:  782498

2007-04-20 11:21:54 0000009031 [20535]:         User Name:  DBA

2007-04-20 11:21:54 0000009031 [20535]:         Est. Temp Space Used (Mb):  1475.8

2007-04-20 11:21:54 0000009031 [20535]:         Effective Number of Users:  1

2007-04-20 11:21:54 0000009031 [20535]:         Number of CPUs:  4

2007-04-20 11:21:54 0000009031 [20535]:         NoExec:  ON

2007-04-20 11:21:54 0000009031 [20535]:         DML_Options2:  8192

2007-04-20 11:21:54 0000009031 [20535]:         Query_Temp_Space_Limit:  0

2007-04-20 11:21:54 0000009031 [20535]:         Simplification 1 source:  (6 -)

2007-04-20 11:21:54 0000009031 [20535]:         Simplification 1 result:  -6

2007-04-20 11:21:54 0000009031 [20535]:         Production 1:  (SACast ((a.ctr_trns_amt))

2007-04-20 11:21:54 0000009031 [20535]:         Output Vector:  6 entries (58 data bytes)

2007-04-20 11:21:54 0000009031 [20535]:         Output 1:  a.ctr_doc_no

2007-04-20 11:21:54 0000009031 [20535]:         Output 1     Data Type:  char (13, 0)

2007-04-20 11:21:54 0000009031 [20535]:         Output 1     Base Distincts (Est.):  35409

2007-04-20 11:21:54 0000009031 [20535]:         Output 1     Indexes:  FP

2007-04-20 11:21:54 0000009031 [20535]:         Output 2:  a.trnsct_real_no_mngt_no

2007-04-20 11:21:54 0000009031 [20535]:         Output 2     Data Type:  char (17, 0)

2007-04-20 11:21:54 0000009031 [20535]:         Output 2     Base Distincts (Est.):  35409

2007-04-20 11:21:54 0000009031 [20535]:         Output 2     Indexes:  FP

2007-04-20 11:21:54 0000009031 [20535]:         Output 3:  a.rpt_fclty_cd

2007-04-20 11:21:54 0000009031 [20535]:         Output 3     Data Type:  char (4, 0)

2007-04-20 11:21:54 0000009031 [20535]:         Output 3     Base Distincts:  2560

2007-04-20 11:21:54 0000009031 [20535]:         Output 3     Indexes:  FP, HG

2007-04-20 11:21:54 0000009031 [20535]:         Output 4:  a.trns_cnt

2007-04-20 11:21:54 0000009031 [20535]:         Output 4     Data Type:  unsigned integer (10, 0)

2007-04-20 11:21:54 0000009031 [20535]:         Output 4     Base Distincts (Est.):  35409

2007-04-20 11:21:54 0000009031 [20535]:         Output 4     Indexes:  FP, HNG

2007-04-20 11:21:54 0000009031 [20535]:         Output 5:  (SACast ((a.ctr_trns_amt))

2007-04-20 11:21:54 0000009031 [20535]:         Output 5     Data Type:  numeric (16, 0)

2007-04-20 11:21:54 0000009031 [20535]:         Output 6:  a.trns_dt

2007-04-20 11:21:54 0000009031 [20535]:         Output 6     Data Type:  char (8, 0)

2007-04-20 11:21:54 0000009031 [20535]:         Output 6     Base Distincts:  452

2007-04-20 11:21:54 0000009031 [20535]:         Output 6     Indexes:  FP, HG

2007-04-20 11:21:54 0000009031 [20535]: 1    #07:  Group By (Hash)

2007-04-20 11:21:54 0000009031 [20535]:         Child Node 1:  #04

2007-04-20 11:21:54 0000009031 [20535]:         Estimated Result Rows:  782498

2007-04-20 11:21:54 0000009031 [20535]:         Inferred XGB semantics (PK):  a.trns_dt

2007-04-20 11:21:54 0000009031 [20535]:         Inferred XGB semantics (PK):  a.ctr_trns_amt

2007-04-20 11:21:54 0000009031 [20535]:         Inferred XGB semantics (PK):  a.trns_cnt

2007-04-20 11:21:54 0000009031 [20535]:         Optimizer est. max hash rows for these keys:  833333

2007-04-20 11:21:54 0000009031 [20535]:         Grouping Expression 1:  a.ctr_doc_no

2007-04-20 11:21:54 0000009031 [20535]:         Grouping Expression 2:  a.trnsct_real_no_mngt_no

2007-04-20 11:21:54 0000009031 [20535]:         Grouping Expression 3:  a.rpt_fclty_cd

2007-04-20 11:21:54 0000009031 [20535]:         Aggregate Expression 1:  ANY(a.trns_dt)

2007-04-20 11:21:54 0000009031 [20535]:         Aggregate Expression 2:  ANY(a.ctr_trns_amt)

2007-04-20 11:21:54 0000009031 [20535]:         Aggregate Expression 3:  ANY(a.trns_cnt)

2007-04-20 11:21:54 0000009031 [20535]:         Output Vector:  6 entries (54 data bytes)

2007-04-20 11:21:54 0000009031 [20535]:         Output 1:  a.ctr_doc_no

2007-04-20 11:21:54 0000009031 [20535]:         Output 2:  a.trnsct_real_no_mngt_no

2007-04-20 11:21:54 0000009031 [20535]:         Output 3:  a.rpt_fclty_cd

2007-04-20 11:21:54 0000009031 [20535]:         Output 4:  a.trns_cnt

2007-04-20 11:21:54 0000009031 [20535]:         Output 5:  a.ctr_trns_amt

2007-04-20 11:21:54 0000009031 [20535]:         Output 6:  a.trns_dt

2007-04-20 11:21:54 0000009031 [20535]: 2    . #04:  Filter

2007-04-20 11:21:54 0000009031 [20535]:           Child Node 1:  #03

2007-04-20 11:21:54 0000009031 [20535]:           Estimated Result Rows:  58552002

2007-04-20 11:21:54 0000009031 [20535]:           Condition 1:

2007-04-20 11:21:54 0000009031 [20535]:             ((b.trns_biz_brnch_nm <> a.trns_biz_brnch_nm) AND b.trns_dt BETWEEN [STRING((CAST( DATEADD(day,-6,(CAST( a.trns_dt AS DATE(10)))) AS VARCHAR(8)) 'yyyymmdd' AS VARCHAR(8))),'000000') AND STRING((CAST( DATEADD(day,6,(CAST( a.trns_dt AS DATE(10)))) AS VARCHAR(8)) 'yyyymmdd' AS VARCHAR(8))),'999999')] )

2007-04-20 11:21:54 0000009031 [20535]:           Condition 1 (Fragment 1):

2007-04-20 11:21:54 0000009031 [20535]:             (b.trns_biz_brnch_nm <> a.trns_biz_brnch_nm)

2007-04-20 11:21:54 0000009031 [20535]:           Condition 1 (Frag. 1) Selectivity:  0.80000000

2007-04-20 11:21:54 0000009031 [20535]:           Condition 1 (Fragment 2):

2007-04-20 11:21:54 0000009031 [20535]:             b.trns_dt BETWEEN [STRING((CAST( DATEADD(day,-6,(CAST( a.trns_dt AS DATE(10)))) AS VARCHAR(8)) 'yyyymmdd' AS VARCHAR(8))),'000000') AND STRING((CAST( DATEADD(day,6,(CAST( a.trns_dt AS DATE(10)))) AS VARCHAR(8)) 'yyyymmdd' AS VARCHAR(8))),'999999')]

2007-04-20 11:21:54 0000009031 [20535]:           Condition 1 (Frag. 2) Selectivity:  0.40000000

2007-04-20 11:21:54 0000009031 [20535]:           Output Vector:  6 entries (54 data bytes)

2007-04-20 11:21:54 0000009031 [20535]:           Output 1:  a.ctr_doc_no

2007-04-20 11:21:54 0000009031 [20535]:           Output 2:  a.trnsct_real_no_mngt_no

2007-04-20 11:21:54 0000009031 [20535]:           Output 3:  a.rpt_fclty_cd

2007-04-20 11:21:54 0000009031 [20535]:           Output 4:  a.trns_cnt

2007-04-20 11:21:54 0000009031 [20535]:           Output 5:  a.ctr_trns_amt

2007-04-20 11:21:54 0000009031 [20535]:           Output 6:  a.trns_dt

2007-04-20 11:21:54 0000009031 [20535]: 3    . . #03:  Join (Sort-Merge)

2007-04-20 11:21:54 0000009031 [20535]:             Left Child Node:  #05

2007-04-20 11:21:54 0000009031 [20535]:             Right Child Node:  #06

2007-04-20 11:21:54 0000009031 [20535]:             Estimated Result Rows:  58552002

2007-04-20 11:21:54 0000009031 [20535]:             Valid Join Algorithms:  NLJ, NLPDJ, SMJ, SMPDJ, HJ, HPDJ

2007-04-20 11:21:54 0000009031 [20535]:             Optimizer est. max hash rows for these keys:  2500000

2007-04-20 11:21:54 0000009031 [20535]:             Optimization Note:

2007-04-20 11:21:54 0000009031 [20535]:               Replaced equated b.ctr_trnsct_real_no_clsf with a.ctr_trnsct_real_no_clsf

2007-04-20 11:21:54 0000009031 [20535]:             Optimization Note:

2007-04-20 11:21:54 0000009031 [20535]:               Replaced equated b.ctr_trnsct_real_no with a.ctr_trnsct_real_no

2007-04-20 11:21:54 0000009031 [20535]:             Left Input Table  1:  adm_dw.b AS b

2007-04-20 11:21:54 0000009031 [20535]:             Estimated Left Inputs:  6162100

2007-04-20 11:21:54 0000009031 [20535]:             Right Input Table 1:  adm_dw.a AS a

2007-04-20 11:21:54 0000009031 [20535]:             Estimated Right Inputs:  6162100

2007-04-20 11:21:54 0000009031 [20535]:             Join Result Constraint:  Many to Many

2007-04-20 11:21:54 0000009031 [20535]:             Condition 1:

2007-04-20 11:21:54 0000009031 [20535]:               (b.ctr_trnsct_real_no_clsf = a.ctr_trnsct_real_no_clsf)

2007-04-20 11:21:54 0000009031 [20535]:             Condition 2:  (b.ctr_trnsct_real_no = a.ctr_trnsct_real_no)

2007-04-20 11:21:54 0000009031 [20535]:             Output Vector:  11 entries (190 data bytes)

2007-04-20 11:21:54 0000009031 [20535]:             Output 1:  a.ctr_doc_no

2007-04-20 11:21:54 0000009031 [20535]:             Output 2:  a.trnsct_real_no_mngt_no

2007-04-20 11:21:54 0000009031 [20535]:             Output 3:  a.rpt_fclty_cd

2007-04-20 11:21:54 0000009031 [20535]:             Output 4:  a.trns_cnt

2007-04-20 11:21:54 0000009031 [20535]:             Output 5:  a.ctr_trns_amt

2007-04-20 11:21:54 0000009031 [20535]:             Output 6:  a.trns_dt

2007-04-20 11:21:54 0000009031 [20535]:             Output 7:  b.trns_biz_brnch_nm

2007-04-20 11:21:54 0000009031 [20535]:             Output 8:  a.trns_biz_brnch_nm

2007-04-20 11:21:54 0000009031 [20535]:             Output 9:  b.trns_dt

2007-04-20 11:21:54 0000009031 [20535]:             Output 10:

2007-04-20 11:21:54 0000009031 [20535]:               STRING((CAST( DATEADD(day,-6,(CAST( a.trns_dt AS DATE(10)))) AS VARCHAR(8)) 'yyyymmdd' AS VARCHAR(8))),'000000')

2007-04-20 11:21:54 0000009031 [20535]:             Output 11:

2007-04-20 11:21:54 0000009031 [20535]:               STRING((CAST( DATEADD(day,6,(CAST( a.trns_dt AS DATE(10)))) AS VARCHAR(8)) 'yyyymmdd' AS VARCHAR(8))),'999999')

2007-04-20 11:21:54 0000009031 [20535]: 4    . . . #05:  Order By

2007-04-20 11:21:54 0000009031 [20535]:               Child Node 1:  #01

2007-04-20 11:21:54 0000009031 [20535]:               Estimated Result Rows:  6162100

2007-04-20 11:21:54 0000009031 [20535]:               Ordering Expression 1:  b.ctr_trnsct_real_no_clsf

2007-04-20 11:21:54 0000009031 [20535]:               Ordering Expression 2:  b.ctr_trnsct_real_no

2007-04-20 11:21:54 0000009031 [20535]:               Output Vector:  4 entries (75 data bytes)

2007-04-20 11:21:54 0000009031 [20535]:               Output 1:  b.trns_biz_brnch_nm

2007-04-20 11:21:54 0000009031 [20535]:               Output 2:  b.trns_dt

2007-04-20 11:21:54 0000009031 [20535]:               Output 3:  b.ctr_trnsct_real_no_clsf

2007-04-20 11:21:54 0000009031 [20535]:               Output 4:  b.ctr_trnsct_real_no

2007-04-20 11:21:54 0000009031 [20535]: 5    . . . . #01:  Leaf

2007-04-20 11:21:54 0000009031 [20535]:                 Estimated Result Rows:  6162100

2007-04-20 11:21:54 0000009031 [20535]:                 Table Name:  adm_dw.b AS b

2007-04-20 11:21:54 0000009031 [20535]:                 Table Row Count:  6162100

2007-04-20 11:21:54 0000009031 [20535]:                 Output Vector:  4 entries (75 data bytes)

2007-04-20 11:21:54 0000009031 [20535]:                 Output 1:  b.trns_biz_brnch_nm

2007-04-20 11:21:54 0000009031 [20535]:                 Output 1     Data Type:  char (50, 0)

2007-04-20 11:21:54 0000009031 [20535]:                 Output 1     Base Distincts (Est.):  35409

2007-04-20 11:21:54 0000009031 [20535]:                 Output 1     Indexes:  FP

2007-04-20 11:21:54 0000009031 [20535]:                 Output 2:  b.trns_dt

2007-04-20 11:21:54 0000009031 [20535]:                 Output 2     Data Type:  char (8, 0)

2007-04-20 11:21:54 0000009031 [20535]:                 Output 2     Base Distincts:  452

2007-04-20 11:21:54 0000009031 [20535]:                 Output 2     Indexes:  FP, HG

2007-04-20 11:21:54 0000009031 [20535]:                 Output 3:  b.ctr_trnsct_real_no_clsf

2007-04-20 11:21:54 0000009031 [20535]:                 Output 3     Data Type:  char (2, 0)

2007-04-20 11:21:54 0000009031 [20535]:                 Output 3     Base Distincts:  10

2007-04-20 11:21:54 0000009031 [20535]:                 Output 3     Indexes:  FP, LF

2007-04-20 11:21:54 0000009031 [20535]:                 Output 4:  b.ctr_trnsct_real_no

2007-04-20 11:21:54 0000009031 [20535]:                 Output 4     Data Type:  char (15, 0)

2007-04-20 11:21:54 0000009031 [20535]:                 Output 4     Base Distincts:  585279

2007-04-20 11:21:54 0000009031 [20535]:                 Output 4     Indexes:  FP, HG

2007-04-20 11:21:54 0000009031 [20535]: 4    . . . #06:  Order By

2007-04-20 11:21:54 0000009031 [20535]:               Child Node 1:  #02

2007-04-20 11:21:54 0000009031 [20535]:               Estimated Result Rows:  6162100

2007-04-20 11:21:54 0000009031 [20535]:               Ordering Expression 1:  a.ctr_trnsct_real_no_clsf

2007-04-20 11:21:54 0000009031 [20535]:               Ordering Expression 2:  a.ctr_trnsct_real_no

2007-04-20 11:21:54 0000009031 [20535]:               Production 1:  (CAST( a.trns_dt AS DATE(10)))

2007-04-20 11:21:54 0000009031 [20535]:               Production 1     Data Type:  date (10, 0)

2007-04-20 11:21:54 0000009031 [20535]:               Production 1     Base Distincts:  452

2007-04-20 11:21:54 0000009031 [20535]:               Production 2:  DATEADD(day,6,(CAST( a.trns_dt AS DATE(10))))

2007-04-20 11:21:54 0000009031 [20535]:               Production 2     Data Type:  date (10, 0)

2007-04-20 11:21:54 0000009031 [20535]:               Production 2     Base Distincts (Est.):  452

2007-04-20 11:21:54 0000009031 [20535]:               Production 3:  DATEADD(day,-6,(CAST( a.trns_dt AS DATE(10))))

2007-04-20 11:21:54 0000009031 [20535]:               Production 3     Data Type:  date (10, 0)

2007-04-20 11:21:54 0000009031 [20535]:               Production 3     Base Distincts (Est.):  452

2007-04-20 11:21:54 0000009031 [20535]:               Production 4:

2007-04-20 11:21:54 0000009031 [20535]:                 (CAST( DATEADD(day,-6,(CAST( a.trns_dt AS DATE(10)))) AS VARCHAR(8)) 'yyyymmdd' AS VARCHAR(8)))

2007-04-20 11:21:54 0000009031 [20535]:               Production 4     Data Type:  varchar (8, 0)

2007-04-20 11:21:54 0000009031 [20535]:               Production 4     Base Distincts (Est.):  452

2007-04-20 11:21:54 0000009031 [20535]:               Production 5:

2007-04-20 11:21:54 0000009031 [20535]:                 (CAST( DATEADD(day,6,(CAST( a.trns_dt AS DATE(10)))) AS VARCHAR(8)) 'yyyymmdd' AS VARCHAR(8)))

2007-04-20 11:21:54 0000009031 [20535]:               Production 5     Data Type:  varchar (8, 0)

2007-04-20 11:21:54 0000009031 [20535]:               Production 5     Base Distincts (Est.):  452

2007-04-20 11:21:54 0000009031 [20535]:               Production 6:

2007-04-20 11:21:54 0000009031 [20535]:                 STRING((CAST( DATEADD(day,6,(CAST( a.trns_dt AS DATE(10)))) AS VARCHAR(8)) 'yyyymmdd' AS VARCHAR(8))),'999999')

2007-04-20 11:21:54 0000009031 [20535]:               Production 7:

2007-04-20 11:21:54 0000009031 [20535]:                 STRING((CAST( DATEADD(day,-6,(CAST( a.trns_dt AS DATE(10)))) AS VARCHAR(8)) 'yyyymmdd' AS VARCHAR(8))),'000000')

2007-04-20 11:21:54 0000009031 [20535]:               Output Vector:  11 entries (149 data bytes)

2007-04-20 11:21:54 0000009031 [20535]:               Output 1:  a.ctr_doc_no

2007-04-20 11:21:54 0000009031 [20535]:               Output 2:  a.trnsct_real_no_mngt_no

2007-04-20 11:21:54 0000009031 [20535]:               Output 3:  a.rpt_fclty_cd

2007-04-20 11:21:54 0000009031 [20535]:               Output 4:  a.trns_cnt

2007-04-20 11:21:54 0000009031 [20535]:               Output 5:  a.ctr_trns_amt

2007-04-20 11:21:54 0000009031 [20535]:               Output 6:  a.trns_dt

2007-04-20 11:21:54 0000009031 [20535]:               Output 7:  a.trns_biz_brnch_nm

2007-04-20 11:21:54 0000009031 [20535]:               Output 8:

2007-04-20 11:21:54 0000009031 [20535]:                 STRING((CAST( DATEADD(day,-6,(CAST( a.trns_dt AS DATE(10)))) AS VARCHAR(8)) 'yyyymmdd' AS VARCHAR(8))),'000000')

2007-04-20 11:21:54 0000009031 [20535]:               Output 8     Data Type:  varchar (14, 0)

2007-04-20 11:21:54 0000009031 [20535]:               Output 8     Base Distincts (Est.):  452

2007-04-20 11:21:54 0000009031 [20535]:               Output 9:

2007-04-20 11:21:54 0000009031 [20535]:                 STRING((CAST( DATEADD(day,6,(CAST( a.trns_dt AS DATE(10)))) AS VARCHAR(8)) 'yyyymmdd' AS VARCHAR(8))),'999999')

2007-04-20 11:21:54 0000009031 [20535]:               Output 9     Data Type:  varchar (14, 0)

2007-04-20 11:21:54 0000009031 [20535]:               Output 9     Base Distincts (Est.):  452

2007-04-20 11:21:54 0000009031 [20535]:               Output 10:  a.ctr_trnsct_real_no_clsf

2007-04-20 11:21:54 0000009031 [20535]:               Output 11:  a.ctr_trnsct_real_no

2007-04-20 11:21:54 0000009031 [20535]: 5    . . . . #02:  Leaf

2007-04-20 11:21:54 0000009031 [20535]:                 Estimated Result Rows:  6162100

2007-04-20 11:21:54 0000009031 [20535]:                 Table Name:  adm_dw.a AS a

2007-04-20 11:21:54 0000009031 [20535]:                 Table Row Count:  6162100

2007-04-20 11:21:54 0000009031 [20535]:                 Declared Primary Key Column 1:  a.ctr_doc_no

2007-04-20 11:21:54 0000009031 [20535]:                 Declared Primary Key Column 2:  a.trnsct_real_no_mngt_no

2007-04-20 11:21:54 0000009031 [20535]:                 Declared Primary Key Column 3:  a.rpt_fclty_cd

2007-04-20 11:21:54 0000009031 [20535]:                 Output Vector:  9 entries (121 data bytes)

2007-04-20 11:21:54 0000009031 [20535]:                 Output 1:  a.ctr_doc_no

2007-04-20 11:21:54 0000009031 [20535]:                 Output 1     Data Type:  char (13, 0)

2007-04-20 11:21:54 0000009031 [20535]:                 Output 1     Base Distincts (Est.):  35409

2007-04-20 11:21:54 0000009031 [20535]:                 Output 1     Indexes:  FP

2007-04-20 11:21:54 0000009031 [20535]:                 Output 2:  a.trnsct_real_no_mngt_no

2007-04-20 11:21:54 0000009031 [20535]:                 Output 2     Data Type:  char (17, 0)

2007-04-20 11:21:54 0000009031 [20535]:                 Output 2     Base Distincts (Est.):  35409

2007-04-20 11:21:54 0000009031 [20535]:                 Output 2     Indexes:  FP

2007-04-20 11:21:54 0000009031 [20535]:                 Output 3:  a.rpt_fclty_cd

2007-04-20 11:21:54 0000009031 [20535]:                 Output 3     Data Type:  char (4, 0)

2007-04-20 11:21:54 0000009031 [20535]:                 Output 3     Base Distincts:  2560

2007-04-20 11:21:54 0000009031 [20535]:                 Output 3     Indexes:  FP, HG

2007-04-20 11:21:54 0000009031 [20535]:                 Output 4:  a.trns_cnt

2007-04-20 11:21:54 0000009031 [20535]:                 Output 4     Data Type:  unsigned integer (10, 0)

2007-04-20 11:21:54 0000009031 [20535]:                 Output 4     Base Distincts (Est.):  35409

2007-04-20 11:21:54 0000009031 [20535]:                 Output 4     Indexes:  FP, HNG

2007-04-20 11:21:54 0000009031 [20535]:                 Output 5:  a.ctr_trns_amt

2007-04-20 11:21:54 0000009031 [20535]:                 Output 5     Data Type:  bigint (16, 0)

2007-04-20 11:21:54 0000009031 [20535]:                 Output 5     Base Distincts (Est.):  35409

2007-04-20 11:21:54 0000009031 [20535]:                 Output 5     Indexes:  FP, HNG

2007-04-20 11:21:54 0000009031 [20535]:                 Output 6:  a.trns_dt

2007-04-20 11:21:54 0000009031 [20535]:                 Output 6     Data Type:  char (8, 0)

2007-04-20 11:21:54 0000009031 [20535]:                 Output 6     Base Distincts:  452

2007-04-20 11:21:54 0000009031 [20535]:                 Output 6     Indexes:  FP, HG

2007-04-20 11:21:54 0000009031 [20535]:                 Output 7:  a.trns_biz_brnch_nm

2007-04-20 11:21:54 0000009031 [20535]:                 Output 7     Data Type:  char (50, 0)

2007-04-20 11:21:54 0000009031 [20535]:                 Output 7     Base Distincts (Est.):  35409

2007-04-20 11:21:54 0000009031 [20535]:                 Output 7     Indexes:  FP

2007-04-20 11:21:54 0000009031 [20535]:                 Output 8:  a.ctr_trnsct_real_no_clsf

2007-04-20 11:21:54 0000009031 [20535]:                 Output 8     Data Type:  char (2, 0)

2007-04-20 11:21:54 0000009031 [20535]:                 Output 8     Base Distincts:  10

2007-04-20 11:21:54 0000009031 [20535]:                 Output 8     Indexes:  FP, LF

2007-04-20 11:21:54 0000009031 [20535]:                 Output 9:  a.ctr_trnsct_real_no

2007-04-20 11:21:54 0000009031 [20535]:                 Output 9     Data Type:  char (15, 0)

2007-04-20 11:21:54 0000009031 [20535]:                 Output 9     Base Distincts:  585279

2007-04-20 11:21:54 0000009031 [20535]:                 Output 9     Indexes:  FP, HG

이 글에 대한 댓글이 총 1건 있습니다.

이거 보고 하시려면 조금 어렵구요


set 옵션주시고 하시거나, 아니면 12.7버젼사용하시면 interactivesql에서 자동으로 plan나옵니다.


그거 참조하시고요


CPU는 별야그 없으면 다 씁니다

지연님이 2007-05-02 17:22에 작성한 댓글입니다. Edit
[Top]
No.
제목
작성자
작성일
조회
1896Sybase==>MsSql로 [3]
한경화
2007-04-28
5186
1895에러메세지가 뜨는데요... 어떻게 해결해야 할지.... [1]
김정훈
2007-04-26
4743
1890oracle에 있는 Connect by와 같은 기능을 하는? [2]
하늘아래
2007-04-23
5907
1889ASIQ 쿼리 플랜정보 확인하기.. [1]
이은영
2007-04-20
6255
1888카탈로그 정보가 필요한데요. [4]
cyber1001
2007-04-19
6465
1887결과가 안나오네요.... ^^: [3]
김정훈
2007-04-18
5436
1886dbm: no open database 이건 뭔가요? [1]
알고싶어요
2007-04-17
4463
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.018초, 이곳 서비스는
	PostgreSQL v16.4로 자료를 관리합니다