Sql performance (Part 5) - Index Seek Vs Index Scan 

Sql performance (Part 5) - Index Seek Vs Index Scan
create clustered index Ix_Demo_Id on [Demo](Id)
create nonclustered index Ix_Demo_Value on [Demo](value)
select * from Demo where value ='Shrikant'
select * from Demo with( index (Ix_Demo_Id)) where value ='Shrikant'