December 2014
Beginner to intermediate
344 pages
7h 34m
English
This chapter will explain the idea of indexing, how it works, and why it is important. This chapter will take you through the basic and advanced concepts of indexing, step by step.
In the chapter, we'll cover the following topics:
To understand the importance of indexing, you need to understand what an index is and its purpose.
In a typical database, an index is an internal structure that is used to increase the speed of data retrieval. An index is a copy of selected data that can be searched very efficiently, which might also include a file-level disk block number or even a direct connection to the entire set of ...
Read now
Unlock full access