推荐的索引

/****************************************************************\
 *                                                               *
 *             Indexes by Paw Index Advisor                      *
 *                                                               *
 *              Powered by PawSQL(2022 - )                       *
 *                                                               *
\****************************************************************/

-- Existing indexes
CREATE INDEX CUSTOMER_PK ON TPCH.CUSTOMER(C_CUSTKEY);
CREATE INDEX CUSTOMER_IBFK_1 ON TPCH.CUSTOMER(C_NATIONKEY);
CREATE INDEX LINEITEM_PK ON TPCH.LINEITEM(L_ORDERKEY,L_LINENUMBER);
CREATE INDEX LINEITEM_IBFK_1 ON TPCH.LINEITEM(L_ORDERKEY);
CREATE INDEX LINEITEM_IBFK_2 ON TPCH.LINEITEM(L_PARTKEY,L_SUPPKEY);
CREATE INDEX NATION_PK ON TPCH.NATION(N_NATIONKEY);
CREATE INDEX NATION_FK1 ON TPCH.NATION(N_REGIONKEY);
CREATE INDEX ORDERS_PK ON TPCH.ORDERS(O_ORDERKEY);
CREATE INDEX ORDERS_IBFK_1 ON TPCH.ORDERS(O_CUSTKEY);
CREATE INDEX PART_PK ON TPCH.PART(P_PARTKEY);
CREATE INDEX PARTSUPP_PK ON TPCH.PARTSUPP(PS_PARTKEY,PS_SUPPKEY);
CREATE INDEX PARTSUPP_IBFK_1 ON TPCH.PARTSUPP(PS_SUPPKEY);
CREATE INDEX PARTSUPP_IBFK_2 ON TPCH.PARTSUPP(PS_PARTKEY);
CREATE INDEX REGION_PK ON TPCH.REGION(R_REGIONKEY);
CREATE INDEX SUPPLIER_PK ON TPCH.SUPPLIER(S_SUPPKEY);
CREATE INDEX SUPPLIER_IBFK_1 ON TPCH.SUPPLIER(S_NATIONKEY);

-- Recommended indexes (After Merging with existing indexes above)
CREATE INDEX SQLLAB_IDX1518532301 ON TPCH.CUSTOMER(C_NATIONKEY,C_CUSTKEY);
CREATE INDEX SQLLAB_IDX1633069825 ON TPCH.LINEITEM(L_PARTKEY,L_SUPPKEY,L_SHIPDATE,L_QUANTITY);
CREATE INDEX SQLLAB_IDX0730967584 ON TPCH.ORDERS(O_CUSTKEY,O_COMMENT,O_ORDERKEY);
CREATE INDEX SQLLAB_IDX1645425553 ON TPCH.PARTSUPP(PS_SUPPKEY,PS_SUPPLYCOST,PS_AVAILQTY,PS_PARTKEY);
CREATE INDEX SQLLAB_IDX1689397061 ON TPCH.SUPPLIER(S_NATIONKEY,S_SUPPKEY);
CREATE INDEX SQLLAB_IDX0989057909 ON TPCH.REGION(R_NAME,R_REGIONKEY);
CREATE INDEX SQLLAB_IDX1895683859 ON TPCH.LINEITEM(L_DISCOUNT,L_SHIPDATE,L_QUANTITY,L_EXTENDEDPRICE);
CREATE INDEX SQLLAB_IDX0864193542 ON TPCH.SUPPLIER(S_NAME,S_NATIONKEY,S_SUPPKEY,S_ADDRESS);
CREATE INDEX SQLLAB_IDX0711368375 ON TPCH.PART(P_TYPE,P_PARTKEY);
CREATE INDEX SQLLAB_IDX1050685658 ON TPCH.LINEITEM(L_PARTKEY,L_SHIPDATE,L_EXTENDEDPRICE,L_DISCOUNT);
CREATE INDEX SQLLAB_IDX0248490817 ON TPCH.ORDERS(O_ORDERPRIORITY,O_ORDERDATE);
CREATE INDEX SQLLAB_IDX0224144590 ON TPCH.PART(P_SIZE,P_TYPE,P_BRAND);
CREATE INDEX SQLLAB_IDX0166915376 ON TPCH.LINEITEM(L_SUPPKEY,L_ORDERKEY,L_SHIPDATE);
CREATE INDEX SQLLAB_IDX0863873348 ON TPCH.LINEITEM(L_SUPPKEY,L_SHIPDATE,L_EXTENDEDPRICE,L_DISCOUNT);
CREATE INDEX SQLLAB_IDX0607681583 ON TPCH.LINEITEM(L_PARTKEY,L_QUANTITY,L_EXTENDEDPRICE);
CREATE INDEX SQLLAB_IDX1716298676 ON TPCH.LINEITEM(L_ORDERKEY,L_QUANTITY);
CREATE INDEX SQLLAB_IDX1968327707 ON TPCH.PARTSUPP(PS_SUPPKEY,PS_PARTKEY,PS_SUPPLYCOST);
CREATE INDEX SQLLAB_IDX1852359742 ON TPCH.ORDERS(O_ORDERDATE,O_ORDERKEY,O_CUSTKEY,O_SHIPPRIORITY);
CREATE INDEX SQLLAB_IDX1409884827 ON TPCH.SUPPLIER(S_SUPPKEY,S_NAME,S_ADDRESS,S_PHONE);
CREATE INDEX SQLLAB_IDX1965289424 ON TPCH.ORDERS(O_ORDERDATE,O_TOTALPRICE,O_ORDERKEY,O_CUSTKEY);