create index nation_1 on nation(n_nationkey);
create index nation_2 on nation(n_name);
create index nation_3 on nation(n_regionkey);
create index nation_4 on nation(n_comment);
create index region_1 on region(r_regionkey);
create index region_2 on region(r_name);
create index region_3 on region(r_comment);
create index lineitem_1 on lineitem(l_orderkey);
create index lineitem_2 on lineitem(l_partkey);
create index lineitem_3 on lineitem(l_suppkey);
create index lineitem_4 on lineitem(l_linenumber);
create index lineitem_5 on lineitem(l_quantity);
create index lineitem_6 on lineitem(l_extendedprice);
create index lineitem_7 on lineitem(l_discount);
create index lineitem_8 on lineitem(l_tax);
create index lineitem_9 on lineitem(l_returnflag);
create index lineitem_10 on lineitem(l_linestatus);
create index lineitem_11 on lineitem(l_shipdate);
create index lineitem_12 on lineitem(l_commitdate);
create index lineitem_13 on lineitem(l_receiptdate);
create index lineitem_14 on lineitem(l_shipinstruct);
create index lineitem_15 on lineitem(l_shipmode);
create index lineitem_16 on lineitem(l_comment);
create index orders_1 on orders(o_orderkey);
create index orders_2 on orders(o_custkey);
create index orders_3 on orders(o_orderstatus);
create index orders_4 on orders(o_totalprice);
create index orders_5 on orders(o_orderdate);
create index orders_6 on orders(o_orderpriority);
create index orders_7 on orders(o_clerk);
create index orders_8 on orders(o_shippriority);
create index orders_9 on orders(o_comment);
create index customer_1 on customer(c_custkey);
create index customer_2 on customer(c_name);
create index customer_3 on customer(c_address);
create index customer_4 on customer(c_nationkey);
create index customer_5 on customer(c_phone);
create index customer_6 on customer(c_acctbal);
create index customer_7 on customer(c_mktsegment);
create index customer_8 on customer(c_comment);
create index partsupp_1 on partsupp(ps_partkey);
create index partsupp_2 on partsupp(ps_suppkey);
create index partsupp_3 on partsupp(ps_availqty);
create index partsupp_4 on partsupp(ps_supplycost);
create index partsupp_5 on partsupp(ps_comment);
create index supplier_1 on supplier(s_suppkey);
create index supplier_2 on supplier(s_name);
create index supplier_3 on supplier(s_address);
create index supplier_4 on supplier(s_nationkey);
create index supplier_5 on supplier(s_phone);
create index supplier_6 on supplier(s_acctbal);
create index supplier_7 on supplier(s_comment);
create index part_1 on part(p_partkey);
create index part_2 on part(p_name);
create index part_3 on part(p_mfgr);
create index part_4 on part(p_brand);
create index part_5 on part(p_type);
create index part_6 on part(p_size);
create index part_7 on part(p_container);
create index part_8 on part(p_retailprice);
create index part_9 on part(p_comment);