Computer scienceFundamentalsSQL and DatabasesDBMSMySQLOptimization

Partitioned Tables

Theory

Partitioning type to choose

Report a typo

Suppose we have a table named supermarket that stores information about various items of the supermarket departments as below:

CREATE TABLE supermarket(
  id INT NOT NULL AUTO_INCREMENT,
  item_name VARCHAR(50) NOT NULL,
  department_name VARCHAR(50) NOT NULL,
  price DECIMAL(10, 2) NOT NULL,
  PRIMARY KEY (id, category)
)

We want to partition the table based on the department name so that each partition contains information for specific items within each department.

Type in the name of the most appropriate partitioning in this case.

Enter a short text
___

Create a free account to access the full topic