小弟我有个视图，去年是0秒，今年变慢了要3-5秒。请大侠小爱和各路大侠帮忙看看啊
日期：2014-05-17 浏览次数：20541 次
我有个视图，去年是0秒，今年变慢了要3-5秒。请大侠小爱和各路大侠帮忙看看啊。
我写的视图很烂，还请大侠们费心看看。
我写的视图很烂，还请大侠们费心看看。
SELECT dbo.Today.Task AS TaskDescr, dbo.Today.No, dbo.Today.Downno,
dbo.Today_2.time4 AS time4, dbo.Today.Via AS bypass, dbo.Today.Hos AS Hos,
dbo.Today.time1 AS time1, dbo.Today.time2 AS time2,
dbo.Today.time5 AS Time5, dbo.Today.time3 AS time3,
dbo.Today.Area AS area, '出' AS io, dbo.Today.Status,
CASE WHEN dbo.Today.ber < 0 THEN '' WHEN dbo.Today.ber IN (1) THEN '南' + CONVERT(varchar,
dbo.Today.ber) WHEN dbo.Today.ber > 17 THEN '北' + CONVERT(varchar, dbo.Today.ber)
ELSE CONVERT(varchar, dbo.Today.ber) END AS Ber, dbo.Today.Gate AS Gate,
dbo.Today.Pla AS Pla, dbo.Today.type,
dbo.Reason.ReasonCN AS DisplayReason, CASE WHEN ltrim(rtrim(dbo.Today.Memo)) = '' AND
ltrim(rtrim(dbo.Today.StatMemo)) <> '' THEN dbo.TodayD.StatMemo WHEN ltrim(rtrim(dbo.Today.Memo))
<> '' AND ltrim(rtrim(dbo.Today.StatMemo))
= '' THEN dbo.Today.Memo WHEN ltrim(rtrim(dbo.Todays.Memo)) <> '' AND
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
