Computer scienceFundamentalsSQL and DatabasesDBMSMySQLOptimization

Partitioned Tables

Range partitioning coding

Report a typo

We have a table named "trips" with columns: id (INT), travel_date (DATE), country_name (VARCHAR), and price (DECIMAL) as below.

CREATE TABLE trips (
    id INT NOT NULL AUTO_INCREMENT,
    travel_date DATE NOT NULL,
    country_name VARCHAR(50) NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    PRIMARY KEY (id, travel_date)
)
INSERT YOUR CODE
(
    PARTITION p0 VALUES LESS THAN (2018),
    PARTITION p1 VALUES LESS THAN (2019),
    PARTITION p2 VALUES LESS THAN (2020),
    PARTITION p3 VALUES LESS THAN (2021),
    PARTITION p4 VALUES LESS THAN (2022),
    PARTITION p5 VALUES LESS THAN MAXVALUE
);

Choose the correct code to put into the 'INSERT YOUR CODE' line in order to partition the trips table by the year of the travel date.

Select one option from the list

PARTITION BY KEY (YEAR(travel_date))

PARTITION BY LIST (YEAR(travel_date))

PARTITION BY RANGE (YEAR(price))

PARTITION BY RANGE (YEAR(travel_date))

___

Create a free account to access the full topic