数据库提高查询效率

[kang_zhi_xiong13456]

ALTER PROCEDURE FindeAllOrderCompanyNO
@companyNO varchar(50),
@supplierNO varchar(50),
@settlement int,
@endDateTime datetime,
@sign bit,
@ticketingTime datetime
AS

declare @sql varchar(max)
SET NOCOUNT ON;
set @sql =' select * from vw_tickDetail_tickorders_tickAirLines where CompanyNO in (select CompanyNO from TicketOrders GROUP by CompanyNO) and GetTicketTime<'''+cast(@endDateTime as varchar(20))+''' and GetTicketTime>='''+cast(@ticketingTime as varchar(20))+''' and GetTicketSign='''+cast(@sign as varchar(20))+''' '
if @companyNO is not null and @companyNO!=''
set @sql +=' and CompanyNO ='''+@companyNO+''''
if @supplierNO is not null and @supplierNO!=''
set @sql +=' and tickDetailSupplierNO='''+@supplierNO+''''
if @settlement !='' and @settlement >-1
set @sql +=' and SettlementStatus='+@settlement+''

print @sql
exec (@sql)
RETURN

各位大侠，用什么办法可以使这个存储的效率更高点

[iihero]

把这个sql打出来看看。我们再分析

[kang_zhi_xiong13456]

怎么没人回答吗

[kang_zhi_xiong13456]

怎么没人回答吗

[ACMAIN_CHM]

仅看你的代码，没什么好办法。

你想实现什么样的功能，看看有没有其它途径。

[永生天地]

只有一个select查询，代码没什么可以优化了，

你在表上建索引优化吧