IF OBJECT_ID(N'dbo.pdd_DataGoods', N'U') IS NOT NULL
   AND NOT EXISTS (
     SELECT 1
     FROM sys.indexes
     WHERE object_id = OBJECT_ID(N'dbo.pdd_DataGoods')
       AND name = N'IX_pdd_DataGoods_createTime_home_dashboard'
   )
BEGIN
  CREATE NONCLUSTERED INDEX IX_pdd_DataGoods_createTime_home_dashboard
  ON dbo.pdd_DataGoods (createTime)
  INCLUDE (
    shopName, goodsUv, goodsPv, payOrdrAmt, payOrdrGoodsQty,
    payOrdrCnt, payOrdrUsrCnt, goodsFavCnt, imprUsrCnt
  );
END;
GO

IF OBJECT_ID(N'dbo.pdd_Evaluation', N'U') IS NOT NULL
   AND NOT EXISTS (
     SELECT 1
     FROM sys.indexes
     WHERE object_id = OBJECT_ID(N'dbo.pdd_Evaluation')
       AND name = N'IX_pdd_Evaluation_createTime_descScore_home'
   )
BEGIN
  CREATE NONCLUSTERED INDEX IX_pdd_Evaluation_createTime_descScore_home
  ON dbo.pdd_Evaluation (createTime, descScore)
  INCLUDE (goodsId, shopName);
END;
GO