CREATE VIEW dbo.ichatUserInfo
AS
SELECT UserID, NickName AS UserName, Password AS UserPassword,
UserSex, UserCredit, UserLevel, UserEnable, UserIcon, UserArming, UserEmail,
UserOicq, UserPhoto, UserResume, UserQuestion, UserAnswer, UserLastIP,
UserMsgCount, CreateDate, ModifyDate, MemberLevel
FROM dbo.UserInfo
go这个视图在实际应用中效率很低,请高手帮忙优化一下,非常感谢
AS
SELECT UserID, NickName AS UserName, Password AS UserPassword,
UserSex, UserCredit, UserLevel, UserEnable, UserIcon, UserArming, UserEmail,
UserOicq, UserPhoto, UserResume, UserQuestion, UserAnswer, UserLastIP,
UserMsgCount, CreateDate, ModifyDate, MemberLevel
FROM dbo.UserInfo
go这个视图在实际应用中效率很低,请高手帮忙优化一下,非常感谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货