• SQL Server training and interview question:-What is index and how does it make your search faster ?.
    Articles,  Blog

    SQL Server training and interview question:-What is index and how does it make your search faster ?.

    In this video will try to understand what exactly is a index and how does index makes such search text faster Lets try to understand what is the goal of index The only goal of a index or the only purposes of a index is to make you search faster How does index actually makes search faster Indexes makes a search faster by creating something called as a B-Tree structure or a Balanced Tree structure internally In this video first lets understand this theory of balanced tree structure Then we will see a practical demonstration of how index makes your search faster Before we start things practically First try to…