回复 3# mdkii 真的是这样,恍然大悟,多谢!另外请教,如果是如下的sql,要想避免ORDER BY C.ACT_TYP, C.ACT_NBR 这两列上的排序,那么索引该如何建立呢? SELECT DISTINCT C.BRF_NAM AS CLT_NAM, C.EMP_NBR AS CLT_EMP_NBR,  ...
显示全部回复 3# mdkii 真的是这样,恍然大悟,多谢!
另外请教,如果是如下的sql,要想避免ORDER BY C.ACT_TYP, C.ACT_NBR 这两列上的排序,那么索引该如何建立呢?
SELECT DISTINCT C.BRF_NAM AS CLT_NAM, C.EMP_NBR AS CLT_EMP_NBR,
C.ORG_NBR AS ORG_NBR, C.ACT_NBR AS ACT_NBR, C.CLT_NBR AS
CLT_NBR, C.ACT_TYP AS ACT_TYP, C.ACT_STS AS ACT_STS,
C.ACT_CRL AS ACT_CRL, C.AVL_CRL AS AVL_CRL, C.TMP_CRL AS
TMP_CRL, C.TMP_CRL_STR_DTE AS TMP_CRL_STR_DTE,
C.TMP_CRL_END_DTE AS TMP_CRL_END_DTE, C.PER_CRL AS
PER_CRL, ROWNUMBER()OVER(
ORDER BY C.ACT_TYP, C.ACT_NBR)AS ROWNUM
FROM ESPDB.F_ACCOUNT AS C
WHERE C.CST_NBR = 9900000498 AND C.ORG_NBR =156 AND C.AVL_CRL <=5000
收起