use qzd_3a
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'etest') DROP INDEX dat_pdjc.etest
CREATE INDEX etest ON qzd_3a..dat_pdjc (jcxz,hphm,hpzl)
合理的索引可快速访问数据库
use qzd_3a
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'etest') DROP INDEX dat_pdjc.etest
CREATE INDEX etest ON qzd_3a..dat_pdjc (jcxz,hphm,hpzl)
合理的索引可快速访问数据库