--TRY
create index index_name on dv_topic(boardid)
create index index_name on dv_board(boardid)
create index index_name1on dv_topic(locktopic)
select top 8 a.topicid,a.title,a.Boardid,b.boardtype,a.dateandtime from dv_topic as a,dv_board as b
where a.boardid=b.boardid and a.boardid not in(777,444,104) and a.locktopic=0 order by a.dateandtime desc
create index index_name on dv_topic(boardid)
create index index_name on dv_board(boardid)
create index index_name1on dv_topic(locktopic)
select top 8 a.topicid,a.title,a.Boardid,b.boardtype,a.dateandtime from dv_topic as a,dv_board as b
where a.boardid=b.boardid and a.boardid not in(777,444,104) and a.locktopic=0 order by a.dateandtime desc
select top 8 a.topicid,a.title,a.Boardid,b.boardtype,a.dateandtime
from dv_topic as a,dv_board as b
where a.boardid=b.boardid and a.boardid <>777 and a.boardid <>444 and a.locktopic=0 and a.boardid <>104
order by a.dateandtime desc
select top 8 a.topicid,a.title,a.Boardid,b.boardtype,a.dateandtime from dv_topic as a,dv_board as b where a.boardid=b.boardid and a.boardid not in(777,444,104) and a.locktopic=0 order by a.dateandtime desc
--TRY
create index index_name on dv_topic(boardid)
create index index_name on dv_board(boardid)
create index index_name1on dv_topic(locktopic)
select top 8 a.topicid,a.title,a.Boardid,b.boardtype,a.dateandtime from dv_topic as a,dv_board as b
where a.boardid=b.boardid and a.boardid not in(777,444,104) and a.locktopic=0 order by a.dateandtime desc
create index index_name on dv_topic(boardid)
create index index_name on dv_board(boardid)
create index index_name1 on dv_topic(locktopic)
select top 8 a.topicid,a.title,a.Boardid,b.boardtype,a.dateandtime from dv_topic as a,dv_board as b
where a.boardid=b.boardid and a.boardid not in(777,444,104) and a.locktopic=0 order by a.dateandtime desc