i think now you see execution plan

now i attached the execution plan

speed is slower than then expected in my windows application with these 6.5 million records

and running command in sql server query designer will take...

I am waiting for execution plan from client side machine.

but i can solve my problem by doing some change in code like this

now i get no problem in 6,55xxxxx records

----------------------

...

- thanks for all who replied upto yet.. .

Database and windows application and web application all are on same pc.

I am creating table via web application and then uses it...