MickyD (9/15/2016)
As an example a very basic select returns (669484 row(s) affected) in around 5 mins.My aim was to see if I could suggest any improvements to the table which could improve and baseline this standard select.
Create some "very basic standard" indexes and do some "very basic standard" maintenance and you will get some improvements.