Covering Index vs Index with included Columns in sql server

[@swatishinde4054]

Thank you..it is very helpful to clear the concept for index with inculcate

[@Chitranjankumar-dg2tl]

Outstanding explanation, Thanks for such useful videos.

[@LearnWithMRajput]

Glad that it is useful

[@christopherhorton9198]

Thanks for your video. It was very clear for me.

[@LearnWithMRajput]

Glad that it is useful

[@abrammakgalemele3491]

Best explanation ever. Thank you!

[@LearnWithMRajput]

Thanks

[@tajudeen2]

Nice 👍

[@marchyppolite9794]

Aha! Thanks. Very resourceful.

[@LearnWithMRajput]

Glad that you like the vedios

[@DamnTimCan]

Thank you but Im still not clear on how the nonclustered index writes the data when Col2 is present vs included.

[@TheSree9120]

If that col2 is in where condition, then can col2 in included would help?

[@Solo_updates]

Thanks madam

[@LearnWithMRajput]

Welcome

[@michaelreynoso2289]

Very well explained

[@LearnWithMRajput]

Thank you

[@akashbhattagi3126]

Learnt something. Good One..!

[@LearnWithMRajput]

Glad to know that you find it useful...happy learning

[@wondingshen534]

tq

[@sainathkompelly4790]

Nice Video. Do you have any documents on performance tuning part? If so,please share

[@LearnWithMRajput]

Hi Sainath, Unfortunately I do not have any documents on performance tuning but soon I will post video on Performance Tuning in SQL Server. Hope that will help you.

[@sainathkompelly4790]

@@LearnWithMRajput Thanks for the reply.I have been facing some report slowness issue on replication server( On subscriber server end).When I have gone through the execution plan of the query Index scan (non clustered index) costing 83% of the query.I have checked the table index but no clusterd index has been created on the table.Should I suggest to create a cluster index to avoid the slowness issue.Awaiting response.

[@LearnWithMRajput]

Yes definitely..

[@sainathkompelly4790]

@@LearnWithMRajput Thanks for the suggestion

[@raghuoruganti3017]

Even Index with included Columns also require some storage space as it is going to append the data of included columns at leaf levels. Please check and confirm

[@aryansena7290]

You are correct.

[@raghuoruganti3017]

Dont refer the name as Nonclustered Table when table has only non cluster index. Please term it as HEAP.