SELECT '00000000267625', A.SGID, EM_BIRTHDAY EM_BIRTHDAY, EM_BUYERID EM_BUYERID, EM_BUYERTYPE EM_BUYERTYPE, EM_CONSUME EM_CONSUME, EM_ID EM_ID, EM_DEPUTY EM_DEPUTY, EM_FAX EM_FAX, J_STATUS, EM_MEMBERNUM EM_MEMBERNUM, EM_MEMBERTYPE EM_MEMBERTYPE, EM_MESSAGE EM_MESSAGE, EM_NAME EM_NAME, EM_PLACE EM_PLACE, '', EM_SEX EM_SEX, '', EM_SOURCE EM_SOURCE, EM_TELA EM_TELA, EM_UPGRADE EM_UPGRADE FROM (SELECT * FROM EMD0030 WHERE EMD0030.EM_PLACE IN ('PL200709000002','PL200709000058','PL200709000067','PL200709000073','PL200709000077','PL200709000081','PL200709000003','PL200709000004','PL200709000010','PL200709000020','PL200709000031','PL200709000037','PL200709000044','PL200709000048','PL200709000052','PL200710000001','PL200710000002','PL200710000003','PL200709000059','PL200709000060','PL200709000061','PL200709000062','PL200709000063','PL200709000064','PL200709000065','PL200709000066','PL200709000068','PL200709000069','PL200709000070','PL200709000071','PL200712000001','PL200709000074','PL200709000075','PL200709000078','PL200709000079','PL200709000080','PL200709000082','PL200709000083','PL200710000005','PL200709000005','PL200709000006','PL200709000007','PL200709000008','PL200709000009','PL200709000014','PL200709000011','PL200709000012','PL200709000013','PL200709000015','PL200709000021','PL200709000026','PL200710000006','PL200709000035','PL200709000032','PL200709000033','PL200709000034','PL200709000036','PL200710000267','PL200709000040','PL200709000039','PL200709000038','PL200709000041','PL200709000042','PL200709000043','PL200711000001','PL200709000045','PL200709000046','PL200709000047','PL200709000050','PL200709000049','PL200709000051','PL200709000057','PL200709000055','PL200709000053','PL200709000054','PL200709000056','PL200711000002','PL200709000022','PL200709000023','PL200709000024','PL200709000025','PL200709000030','PL200709000027','PL200709000028','PL200709000029') AND EMD0030.J_STATUS = 'A' ORDER BY EM_BUYERID) A WHERE ROWNUM<=20 MINUS SELECT '00000000267625', A.SGID, EM_BIRTHDAY EM_BIRTHDAY, EM_BUYERID EM_BUYERID, EM_BUYERTYPE EM_BUYERTYPE, EM_CONSUME EM_CONSUME, EM_ID EM_ID, EM_DEPUTY EM_DEPUTY, EM_FAX EM_FAX, J_STATUS, EM_MEMBERNUM EM_MEMBERNUM, EM_MEMBERTYPE EM_MEMBERTYPE, EM_MESSAGE EM_MESSAGE, EM_NAME EM_NAME, EM_PLACE EM_PLACE, '', EM_SEX EM_SEX, '', EM_SOURCE EM_SOURCE, EM_TELA EM_TELA, EM_UPGRADE EM_UPGRADE FROM (SELECT * FROM EMD0030 WHERE EMD0030.EM_PLACE IN ('PL200709000002','PL200709000058','PL200709000067','PL200709000073','PL200709000077','PL200709000081','PL200709000003','PL200709000004','PL200709000010','PL200709000020','PL200709000031','PL200709000037','PL200709000044','PL200709000048','PL200709000052','PL200710000001','PL200710000002','PL200710000003','PL200709000059','PL200709000060','PL200709000061','PL200709000062','PL200709000063','PL200709000064','PL200709000065','PL200709000066','PL200709000068','PL200709000069','PL200709000070','PL200709000071','PL200712000001','PL200709000074','PL200709000075','PL200709000078','PL200709000079','PL200709000080','PL200709000082','PL200709000083','PL200710000005','PL200709000005','PL200709000006','PL200709000007','PL200709000008','PL200709000009','PL200709000014','PL200709000011','PL200709000012','PL200709000013','PL200709000015','PL200709000021','PL200709000026','PL200710000006','PL200709000035','PL200709000032','PL200709000033','PL200709000034','PL200709000036','PL200710000267','PL200709000040','PL200709000039','PL200709000038','PL200709000041','PL200709000042','PL200709000043','PL200711000001','PL200709000045','PL200709000046','PL200709000047','PL200709000050','PL200709000049','PL200709000051','PL200709000057','PL200709000055','PL200709000053','PL200709000054','PL200709000056','PL200711000002','PL200709000022','PL200709000023','PL200709000024','PL200709000025','PL200709000030','PL200709000027','PL200709000028','PL200709000029') AND EMD0030.J_STATUS = 'A' ORDER BY EM_BUYERID) A WHERE ROWNUM<=0
这点语句在PL/SQL中执行大约七秒左右,测试发现,是由于IN语句后面的地区太多,有没有方法可以提升查询速度,请帮忙!