-- Index

-- 品目基本属性
DROP INDEX t_item_basic_attr_idx2;
CREATE INDEX t_item_basic_attr_idx2 ON t_item_basic_attr (stock_upddate);

DROP INDEX t_item_basic_attr_idx3;
CREATE INDEX t_item_basic_attr_idx3 ON t_item_basic_attr (itemnm);

DROP INDEX t_item_basic_attr_idx5;
CREATE INDEX t_item_basic_attr_idx5 ON t_item_basic_attr (lowprice, newlowprice, oldlowprice);

DROP INDEX t_item_basic_attr_idx6;
CREATE INDEX t_item_basic_attr_idx6 ON t_item_basic_attr (min_salestartdate);



-- 品目ウェブ属性
DROP INDEX t_item_web_attr_idx1;
CREATE INDEX t_item_web_attr_idx1 ON t_item_web_attr (delflg, releasedate);



-- 出品在庫明細
DROP INDEX t_ex_stock_detail_idx1;
CREATE INDEX t_ex_stock_detail_idx1 ON t_ex_stock_detail (delflg);

DROP INDEX t_ex_stock_detail_idx2;
CREATE INDEX t_ex_stock_detail_idx2 ON t_ex_stock_detail USING btree (sellercd, stockstate, condition, exhibitcount);


-- 品目構成属性
DROP INDEX t_item_struct_idx1;
CREATE INDEX t_item_struct_idx1 ON t_item_struct (delflg);

DROP INDEX t_item_struct_idx2;
CREATE INDEX t_item_struct_idx2 ON t_item_struct (salestartdate);

DROP INDEX t_item_struct_idx3;
CREATE INDEX t_item_struct_idx3 ON t_item_struct USING btree (makeritemcd);

-- ランキング
DROP INDEX t_ranking_idx1;
CREATE INDEX t_ranking_idx1 ON t_ranking USING btree (rankingtype,date,rankingrate);