有如下SQL
SELECT * FROM PERTCKER
WHERE (NAME=? OR ? IS NULL)
AND (AGE=? OR ? IS NULL)
AND (SCHOOL=? OR ? IS NULL)
FOR UPDATE
表索引如下:
PERTCKER_NI:CHK_ERR_DT,ERR_STS
PERTCKER_PK:NAME,SCHOOL,AGE
如何分析和解决这个SQL
SELECT * FROM PERTCKER
WHERE (NAME=? OR ? IS NULL)
AND (AGE=? OR ? IS NULL)
AND (SCHOOL=? OR ? IS NULL)
FOR UPDATE
表索引如下:
PERTCKER_NI:CHK_ERR_DT,ERR_STS
PERTCKER_PK:NAME,SCHOOL,AGE
如何分析和解决这个SQL
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货