In this example, column d1 has a Period data type. CREATE JOIN INDEX ji_pdt AS SELECT b1, c1, d1 FROM t1;