select id,bt,dian,hui,hot from ["+boardid+"] where hotid='{0}' ORDER BY htsj DESC这是我写的SQL,["+boardid+"]是表名,'{0}'是条件,他2都是动态的, 可我感觉这样写查起来老慢了 那为高手能帮我优化一下啊
直接: select id,bt,dian,hui,hot from boardid where hotid=0 ORDER BY htsj DESC 是不是索引有问题
declare @sql as varchar(4000) declare @tb as varchar(10) declare @hotid as int set @tb = 'boardid' set @hotid = 0set @sql = 'select id,bt,dian,hui,hot from ' + @tb + ' where hotid = ' + cast(@hotid as varchar) + ' ORDER BY htsj DESC'exec(@sql)
select id,bt,dian,hui,hot from boardid where hotid=0 ORDER BY htsj DESC
是不是索引有问题
declare @tb as varchar(10)
declare @hotid as int
set @tb = 'boardid'
set @hotid = 0set @sql = 'select id,bt,dian,hui,hot from ' + @tb + ' where hotid = ' + cast(@hotid as varchar) + ' ORDER BY htsj DESC'exec(@sql)