Given the following PPI table:
CREATE TABLE SalesHistory_Store1(
Product_CodeCHAR(8)
, Store_Number INTEGER
, Transaction_Date DATE
, Quantity_Sold INTEGER
, Notes CHAR(50))
PRIMARY INDEX (Product_Code, Store_Number, Transaction_Date)
PARTITION BY RANGE_N (Transaction_Date BETWEEN
DATE '2009-01-01' AND DATE '2011-12-31' EACH INTERVAL '1' DAY);
Which table, when joined with the given table, may result in a rowkey-based merge join?
- CREATE TABLE SalesHistory_Store2(
Product_CodeCHAR(8)
, Store_Number INTEGER
, Transaction_Date DATE
, Quantity_Sold INTEGER)
PRIMARY INDEX (Product_Code, Store_Number, Transaction_Date)
PARTITION BY RANGE_N (Transaction_Date BETWEEN
DATE '2009-01-01' AND DATE '2011-12-31' EACH INTERVAL '1' DAY);
- CREATE TABLE SalesHistory_Store2(
Product_CodeCHAR(8)
, Store_Number INTEGER
, Transaction_Date DATE
, Quantity_Sold INTEGER
, Notes CHAR(50))
PRIMARY INDEX (Product_Code, Store_Number)
PARTITION BY RANGE_N (Transaction_Date BETWEEN
DATE '2009-01-01' AND DATE '2011-12-31' EACH INTERVAL '1' DAY);
- CREATE TABLE SalesHistory_Store2(
Product_CodeCHAR(8)
, Store_Number INTEGER
, Transaction_Date DATE
, Quantity_Sold INTEGER
, Notes CHAR(50))
PRIMARY INDEX (Product_Code, Store_Number, Transaction_Date)
PARTITION BY RANGE_N (Transaction_Date BETWEEN
DATE '2009-01-01' AND DATE '2011-12-31' EACH INTERVAL '1' MONTH);
- CREATE TABLE SalesHistory_Store2(
Product_CodeCHAR(8)
, Store_Number INTEGER
, Transaction_Date DATE
, Quantity_Sold INTEGER
, Notes CHAR(50))
PRIMARY INDEX (Product_Code, Store_Number, Transaction_Date)
Reveal Solution
Next Question