解決方法就是在order by ID desc再加一個排序的字段，這樣子可能會把速度提高很多。再加止排序的字段因查詢而異了 
如表 

復制代碼代碼如下:

CREATE TABLE [dbo].[CMPP_SendCentre] ( 
[id] [int] IDENTITY (1, 1) NOT NULL , 
[SendType] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , 
[SendDate] [datetime] NOT NULL , 
[Port] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , 
[Service_ID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , 
[FeeType] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , 
[FeeCode] [varchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL , 
[Msg_Content] [varchar] (1024) COLLATE Chinese_PRC_CI_AS NOT NULL , 
[SendCount] [int] NOT NULL , 
[SucceedCount] [int] NOT NULL 
) ON [PRIMARY] 
GO 
CREATE TABLE [dbo].[CMPP_SendCentreMo] ( 
[id] [int] IDENTITY (1, 1) NOT NULL , 
[SendCentreID] [int] NOT NULL , 
[Mo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , 
[Stat] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] 
GO 
CMPP_SendCentreMo.SendCentreID 與CMPP_SendCentre.ID成外建關系 

于是建了一個視圖 

復制代碼代碼如下:

CREATE VIEW dbo.ViewCMPP_SendCentreMo 
AS 
SELECT 
dbo.CMPP_SendCentreMo.id, 
dbo.CMPP_SendCentreMo.SendCentreID, 
dbo.CMPP_SendCentreMo.Mo, 
dbo.CMPP_SendCentreMo.Stat, 
dbo.CMPP_SendCentre.SendType, 
dbo.CMPP_SendCentre.SendDate, 
dbo.CMPP_SendCentre.Port, 
dbo.CMPP_SendCentre.Service_ID, 
case dbo.CMPP_SendCentre.FeeType when '01' then '免費' when '02' then '點播' else '包月' end as FeeType, 
cast(dbo.CMPP_SendCentre.FeeCode as smallint) as FeeCode, 
dbo.CMPP_SendCentre.Msg_Content 
FROM dbo.CMPP_SendCentre INNER JOIN 
dbo.CMPP_SendCentreMo ON 
dbo.CMPP_SendCentre.id = dbo.CMPP_SendCentreMo.SendCentreID 

一開始的查詢語句為 

復制代碼代碼如下:

select top 6*from [ViewCMPP_SendCentreMo] 
where SendType = '扣費' 
order by id desc 

發現非常的慢 
經過了解,原因是order by id desc/asc的查詢是一行一行的找數據,所以非常的慢 
于是改成了 

復制代碼代碼如下:

select top 6*from [ViewCMPP_SendCentreMo] 
where SendType = '扣費' 
order by SendCentreID desc, id desc 

查詢就非常的快了