Tip:
Highlight text to annotate it
X
Pinal Dave: In this module we will discuss SQL server indexing fundamentals
and the basic building blocks of indexing.
Real life is very close to technology.
Every skyscraper needs a stronger base.
If the base is not strong the building will not last.
Just like that, in technology we need strong fundamentals.
Indexing, which is considered as an effective solution
in most cases needs proper understanding.
One inefficient index can really degrade the performance of a server.
Vinod, will you please explain this concept to us from the beginning?
It would be really nice to see how pages, extents,
heaps and other indexing concepts are built using the SQL code.
Additionally, if you can explain this concept using easy 14 00:00:52,256 to understand diagrams it will give us a better understanding.