GilaMonster (8/10/2010)
In the initial post, neither of the order by statements matched the clustered index
Ok agree but see the below case with exec plan
truncate table email_destination_bk
insert into email_destination_bk
select ut_stub,acct_id , evt_stub , evt_code
from email_source_bk
where acct_id = 2000122
order by evt_stub
truncate table email_destination_bk
insert into email_destination_bk
select ut_stub,acct_id , evt_stub , evt_code
from email_source_bk
where acct_id = 2000122
order by acct_id,evt_code
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)