Table partitioning

Partitioning is a feature in DBMS which segregates large amounts of data into multiple segments based on an attribute of a relation. Using this as a feature, we can perform operations effectively on large datasets. We can also go without partitioning the large datasets, but eventually we'll need to pay for performance as a result. The query response time and the amount of data it processes are inversely proportional. So, in short, the more data we have, the less performance we get (where performance is the actual time of query execution).

For example, consider we have a global business where we store all our global customers' information in our local database as follows:

CREATE TABLE customers
(id integer,
name varchar(126),
countrycode varchar(3),
contactnum text);

In the preceding table, we will store all our global customer details along with the countrycode. For demonstration purposes, I am going to use three-character country names, which are generated randomly from...