Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

To improve query performance, the Country table is partitioned as follows: CREATE TABLE Country ( Code INT, Name VARCHAR ( 1 5 ) , IndependenceDate

To improve query performance, the Country table is partitioned as follows:
CREATE TABLE Country (
Code INT,
Name VARCHAR(15),
IndependenceDate DATE,
Capital VARCHAR(15)
)
PARTITION BY RANGE (___(A)___(IndependenceDate))(
PARTITION p1 VALUES LESS THAN (___(B)___),
PARTITION p2 VALUES LESS THAN (1834),
PARTITION p3 VALUES LESS THAN (1867),
PARTITION p4 VALUES LESS THAN (1900),
PARTITION p5 VALUES LESS THAN ___(C)___
);Complete the values of A, B and C:
(A)
(B)
(C)# Less than 1800
# 1800 through 1833
# 1834 through 1866
# 1867 through 1899
# Greater than 1900

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Objects And Databases International Symposium Sophia Antipolis France June 13 2000 Revised Papers Lncs 1944

Authors: Klaus R. Dittrich ,Giovanna Guerrini ,Isabella Merlo ,Marta Oliva ,M. Elena Rodriguez

2001st Edition

ISBN: 3540416641, 978-3540416647

More Books

Students also viewed these Databases questions