数据库提高查询效率

2010-05-26 11:48:40 122 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

kang_zhi_xiong13456 墨衍会员 · AI 创作全网分发关注 + 加入社区

在大型数据库数据查询时如何提高查询效率？转载于https://blog.csdn.net/xlgen157387/article/details/44156679 一、数据库设计方面 1、对查询进行优化，应尽量避免全表扫描，首先应考虑在 where 及 order by 涉及的列上建立索引； 2、应尽量避免在 where 子句中对字段进行 null 值判断，否则将导致引擎放弃使用索引而进行全表扫描，如： select id fro... 阅读详情

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

各位大侠，，怎么修改才能使这个存储过程提高查询效率

...全文