在公司测试环境中，遇到一例case

同样一例sql语句

1.当在plsql工具sql窗口中执行

SELECT COUNT(1)
  FROM PS_PART           PP,
       PS_PART_MASTER    PM,
       PS_SBOM           PS,
       PS_PART_USAGELINK U,
       PS_PART           UP,
       PS_PART_MASTER    UPM,
       PS_PART_USAGELINK MU,
       PS_PART           MUP,
       PS_PART_MASTER    MUPM
 WHERE PP.SERIAL_ID = PS.SERIAL_ID
   AND PP.MASTER_SEIRAL_ID = PM.SERIAL_ID
复制

执行时间需要1分钟以上

2.当在plsql工具命令窗口中执行

SELECT COUNT(1)
  FROM PS_PART           PP,
       PS_PART_MASTER    PM,
       PS_SBOM           PS,
       PS_PART_USAGELINK U,
       PS_PART           UP,
       PS_PART_MASTER    UPM,
       PS_PART_USAGELINK MU,
       PS_PART           MUP,
       PS_PART_MASTER    MUPM
 WHERE PP.SERIAL_ID = PS.SERIAL_ID
   AND PP.MASTER_SEIRAL_ID = PM.SERIAL_ID
复制

执行时间需要1秒

3.当在sqlplus工具与DBEAVER工具中执行中执行

SELECT COUNT(1)
  FROM PS_PART           PP,
       PS_PART_MASTER    PM,
       PS_SBOM           PS,
       PS_PART_USAGELINK U,
       PS_PART           UP,
       PS_PART_MASTER    UPM,
       PS_PART_USAGELINK MU,
       PS_PART           MUP,
       PS_PART_MASTER    MUPM
 WHERE PP.SERIAL_ID = PS.SERIAL_ID
   AND PP.MASTER_SEIRAL_ID = PM.SERIAL_ID
复制

执行时间需要1秒

4.当在plsql工具sql窗口中执行

SELECT COUNT(1)
  FROM PDM.PS_PART           PP,
       PDM.PS_PART_MASTER    PM,
       PDM.PS_SBOM           PS,
       PDM.PS_PART_USAGELINK U,
       PDM.PS_PART           UP,
       PDM.PS_PART_MASTER    UPM,
       PDM.PS_PART_USAGELINK MU,
       PDM.PS_PART           MUP,
       PDM.PS_PART_MASTER    MUPM
 WHERE PP.SERIAL_ID = PS.SERIAL_ID
   AND PP.MASTER_SEIRAL_ID = PM.SERIAL_ID
   AND PP.ENABLED_FLAG = 1
复制

执行时间需要1秒

用户均为PDM，请问都是一样的sql，为什么第一种方式执行，需要耗时这么多