I have a table with more than 1 million rows.
When I execute a simple SELECT query it takes about 17 seconds to retrieve the data.
SELECT * FROM MyTable
The execution plan gives the following info:
Furthermore, I have 5 non-clustered indexes and one clustered index.
Any suggestion would be appreciated.