Sql performance (Part 6) - RID Look Up ||How to fix it. 

Sql performance (Part 6) - RID Look Up ||How to fix it.
create nonclustered index Ix_Demo_Value on [Demo](value)
drop index Ix_Demo_Value on [Demo]
create nonclustered index Ix_Demo_Value on [Demo](value,Id)