下面的两个select语句,哪位大哥知道有更好的效率改善啊。
不管是创建索引还是什么的。
Declare @P_int_TotalCount int
SELECT @P_int_TotalCount = COUNT(ORDER_ID)
from A
where replace(A.bill_to_phone,'-','') like '087350%' and A.LABEL='EO'
SELECT Label,ORDER_ID as IDQO,convert(varchar, ORDER_TMS, 111) + ' ' + convert(varchar, ORDER_TMS, 108) as ORDER_TMS, CUSTOMER_NAME, ORDER_TOTAL,DELY_FEE,FOS_FLAG,EMAIL,BILL_TO_NAME,BILL_TO_COMP,DEPT_CODE,PrC , @P_int_TotalCount as CNT1
from A
where replace(A.bill_to_phone,'-','') like '087350%' and A.LABEL='EO' ORDER BY ORDER_ID DESC目前已经存在3个索引 CREATE CLUSTERED INDEX [IX1] ON [dbo].[A]([ORDER_TMS]) WITH FILLFACTOR = 80 CREATE INDEX [IX2] ON [dbo].[A]([ACTUAL_SEGMENT]) WITH FILLFACTOR = 80 CREATE INDEX [IX3] ON [dbo].[A]([LABEL], [ORDER_ID], [FOS_FLAG], [ACTUAL_SEGMENT]) WITH FILLFACTOR = 80
不管是创建索引还是什么的。
Declare @P_int_TotalCount int
SELECT @P_int_TotalCount = COUNT(ORDER_ID)
from A
where replace(A.bill_to_phone,'-','') like '087350%' and A.LABEL='EO'
SELECT Label,ORDER_ID as IDQO,convert(varchar, ORDER_TMS, 111) + ' ' + convert(varchar, ORDER_TMS, 108) as ORDER_TMS, CUSTOMER_NAME, ORDER_TOTAL,DELY_FEE,FOS_FLAG,EMAIL,BILL_TO_NAME,BILL_TO_COMP,DEPT_CODE,PrC , @P_int_TotalCount as CNT1
from A
where replace(A.bill_to_phone,'-','') like '087350%' and A.LABEL='EO' ORDER BY ORDER_ID DESC目前已经存在3个索引 CREATE CLUSTERED INDEX [IX1] ON [dbo].[A]([ORDER_TMS]) WITH FILLFACTOR = 80 CREATE INDEX [IX2] ON [dbo].[A]([ACTUAL_SEGMENT]) WITH FILLFACTOR = 80 CREATE INDEX [IX3] ON [dbo].[A]([LABEL], [ORDER_ID], [FOS_FLAG], [ACTUAL_SEGMENT]) WITH FILLFACTOR = 80
把第三个索引的列中,去掉label之外的.