select d.departname 部门,a.plan_num 计划号,a.plan_row_num 计划行号,a.purchase_order_num 订单号,a.purchase_order_line_item_code 订单行号,a.full_approval_flag 计划审批状态,a.material_code 物资编码,a.material_description 物资描述,e.material_code 集采物资编码,f.material_code 一级集采目录物资,a.submission_date 提报日期,g.distribution_date 计划下发日期,a.order_creation_date 订单日期,a.category_code 大类,a.category_name 大类描述,a.arrival_place 到货地点,a.product_code 物料组,a.product_name 物料组描述,a.reporting_depart_name 提报单位名称,a.unit 单位,a.demand_count 需求数量,a.amount 金额,b.supplier_name 供应商名称,a.investment_plan_code 投资计划号,b.materia_grade 物资等级,c.name 采购方式名称from material_china_plan aleft join material_china_order bon a.plan_num=b.plan_numand a.plan_row_num=b.plan_row_numleft join sys_pur_method con b.procurement_method_code=c.codeleft join sys_depart_class d on a.category_code=d.classcodeleft join material_annual_purchase_detail eon a.material_code=e.material_codeleft join material_first_level_catalog fon a.material_code=f.material_codeleft join material_china_plan_distribution gon a.plan_num=g.plan_numand a.plan_row_num=g.plan_row_numwhere d.rq='2022'and a.full_approval_flag ='已审批通过' AND a.storage_and_sales_agency='否' and a.plan_status_description !='物采系统退回' AND a.plan_status_code != '99' AND a.investment_plan_code IS NULL AND a.demand_list_num IS NULL AND a.submission_date>=('2022')and a.submission_date<=('2023')order by a.category_code asc仅按照上述sql而言 应该以怎样的一个顺序为a表建立索引，其他表建完了。
