22亿单表，设置有绑定变量，传入不同数值以后，执行计划改变。

==========================================================

SELECT

XF_SBH NSRSBM,

HW_MC HWMC,

MIN(KPNY) KPYF_QS,

MAX(KPNY) KPYF_JZ,

SUM(JE) JE

  FROM FPFX_T_FP_HZ

WHERE JE is not null

   and XF_SBH = :1

GROUP BY XF_SBH, HW_MC

Description	Object owner	Object name	Cost	Cardinality	Bytes
SELECT STATEMENT, GOAL = ALL_ROWS			269	203	10,353
HASH GROUP BY			269	203	10,353
TABLE ACCESS BY INDEX ROWID	FPFX	FPFX_T_FP_HZ	268	287	14,637
INDEX RANGE SCAN	FPFX	FPFX_T_FP_HZ_XF_SBH	5	291

=================================================================================================

SELECT

XF_SBH NSRSBM,

HW_MC HWMC,

MIN(KPNY) KPYF_QS,

MAX(KPNY) KPYF_JZ,

SUM(JE) JE

  FROM FPFX_T_FP_HZ

WHERE JE is not null