select CLASS_ID,CLASS_NAME,CLASS_INFO,TOPIC_ID,CLASS_LASTTITLE,CLASS_LASTTIME,CLASS_LASTUSER,USER_TYPE,
(select count(TOPIC_FORUMID) FROM KY_FORUM_TOPIC where TOPIC_FORUMID=CLASS_ID)as aa,
(select count(TOPIC_FORUMID) FROM KY_FORUM_TOPIC where TOPIC_FORUMID=CLASS_ID
and TOPIC_TIME>=to_Date('2012-4-24 0:00:00','yyyy-mm-dd HH24:mi:ss')) as bb,
(select count(REPLY_ID) FROM KY_FORUM_REPLY where REPLY_CLASSID=CLASS_ID)as cc
FROM KY_FORUM_CLASS where CLASS_STATE=0 and CLASS_TYPE=1 order by CLASS_SORT这个执行完毕2秒多能不能再快点?
(select count(TOPIC_FORUMID) FROM KY_FORUM_TOPIC where TOPIC_FORUMID=CLASS_ID)as aa,
(select count(TOPIC_FORUMID) FROM KY_FORUM_TOPIC where TOPIC_FORUMID=CLASS_ID
and TOPIC_TIME>=to_Date('2012-4-24 0:00:00','yyyy-mm-dd HH24:mi:ss')) as bb,
(select count(REPLY_ID) FROM KY_FORUM_REPLY where REPLY_CLASSID=CLASS_ID)as cc
FROM KY_FORUM_CLASS where CLASS_STATE=0 and CLASS_TYPE=1 order by CLASS_SORT这个执行完毕2秒多能不能再快点?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货