SQL Primer: An Accelerated Introduction to SQL Basics

©  Rahul Batra 2018

Rahul BatraSQL Primerhttps://doi.org/10.1007/978-1-4842-3576-8_15

15. Indexing

Rahul Batra¹ 

(1)

Gurgaon, Haryana, India

 

Databases have long been the primary data storage components from which insights are derived. As businesses increasingly adopt technology-enabled workflows, the rate of data generation has grown substantially. This trend has accelerated with the adoption of the Internet and mobile computing.

A well-sized relational database used to run into hundreds of megabytes in the 1990s. It is not uncommon to hear of database systems running into hundreds of gigabytes or even a few terabytes nowadays. As a professional, you will frequently encounter tables with million rows in them.

Until now we have seen the parts of SQL ...