条件任意保留一个，查询时间2秒，两个条件同时保留需要2分钟，请问是什么原因，数据库是oracle

Question

select distinct rt.task_id taskId
  from B_MATERIAL_STORE_RECEIVE msr
  left join B_RECEIVE_TASK rt on msr.id = rt.materialstore_receive_id
  left join wbs_task t on rt.task_id = t.id
  left join wbs_task_detail wtd on wtd.id = t.taskdetailid
 where 1 = 1
   and wtd.project_id = 2973660594
   and wtd.construct_company_id = 38758069
   and msr.entity_status = 'completed'

Answer 1

调整一下条件的顺序试试；oracle自带的sqldeveloper有个sql优化指导功能，可以试一下