I've one table (ID (bigint), Word nvarchar(400), WordCount bigint) with records of 700000.
ID column is Primary Key with Clustered Index.
Now, if I run query SELECT * FROM tableName. It takes 11 seconds
Then, I put another non-clustered index on "Word" but still takes 10 seconds.
Any further suggestion on it?