I have a select statement, in which three tables are being inner joined and one of the table has 120 columns in it and almost all of the columns are being returned in the select statement from this big table. The execution plan shows clustered index seek only for all the tables. Looking for any out of the box ideas to make the select work more faster.
What I have tried:
I applied page compression for the big table and it yielded 10 seconds improvement, but still i want to tune it further.