查看其它 4 个回答richard_macy的回答
fetch first 10 rows only with ur 需要 1 分钟 总 是 有问题。
EXPLAIN 很简单
Statement:
select *
from richard.CMRM_PROD_DIM
fetch first 10 rows only
with ur
Statement Isolation Level = Uncommitted Read
Intra-Partition Parallelism Degree = 16
Section Code Page = 1208
Estimated Cost = 7.201596
Estimated Cardinality = 10.000000
CDE Subquery
| Tables Referenced:
| | 1: RICHARD.CMRM_PROD_DIM ID = 2,45
| #Output Columns = 121
Return Data to Application
| #Columns = 121
End of section
Optimizer Plan:
Rows
Operator
(ID)
Cost
10
RETURN
( 1)
7.2016
|
10
CTQ
( 2)
7.2016
|
*
|
1.10753e+07
Table:
RICHARD
CMRM_PROD_DIM
EXPLAIN 很简单
Statement:
select *
from richard.CMRM_PROD_DIM
fetch first 10 rows only
with ur
Statement Isolation Level = Uncommitted Read
Intra-Partition Parallelism Degree = 16
Section Code Page = 1208
Estimated Cost = 7.201596
Estimated Cardinality = 10.000000
CDE Subquery
| Tables Referenced:
| | 1: RICHARD.CMRM_PROD_DIM ID = 2,45
| #Output Columns = 121
Return Data to Application
| #Columns = 121
End of section
Optimizer Plan:
Rows
Operator
(ID)
Cost
10
RETURN
( 1)
7.2016
|
10
CTQ
( 2)
7.2016
|
*
|
1.10753e+07
Table:
RICHARD
CMRM_PROD_DIM
浏览757