even when I tried to retrieve 5 columns still taking more than 10 min

Hi,

Already I posed the execution plan. There is only one table with 70 columns and only 1 primary key (with 12 columns). Apart from that there is no other index...

Hi Neil,

Thanks for your reply

I am using SQL Server 2012, and when I am trying to query the table directly as

select * from test

also I tried by giving column...