Advertisement
Guest User

Untitled

a guest
Feb 11th, 2019
228
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.80 KB | None | 0 0
  1. WITH cte_000000000A110690_17 AS (SELECT t_03.puid AS revPuid, t_04.pdate_released AS revDateRel, t_03.ritems_tagu AS myItem, t_04.puid AS rlsPuid, t_04.pname AS rlsName FROM PWORKSPACEOBJECT t_01 , PRELEASE_STATUS_LIST t_02 , PITEMREVISION t_03 , PRELEASESTATUS t_04,#PRefbindtag3 WHERE ( ( ( ( ( t_03.ritems_tagu = #PRefbindtag3.puid AND ( t_04.pdate_released <= CONVERT(datetime, '2019-02-11 06:16:21', 120) ) ) AND ( t_04.pname = 'F' ) ) AND ( t_02.pvalu_0 = t_04.puid ) ) AND ( t_01.pactive_seq != 0 ) ) AND ( t_01.puid = t_02.puid AND t_02.puid = t_03.puid ) ) ) SELECT DISTINCT t_06.myItem, t_06.revPuid, t_07.rDate, t_06.rlsPuid FROM cte_000000000A110690_17 t_06 , (SELECT MAX ( t_05.revDateRel ) AS rDate, t_05.myItem AS dtItem FROM cte_000000000A110690_17 t_05 GROUP BY t_05.myItem) t_07 WHERE ( ( ( t_06.myItem = t_07.dtItem ) AND ( t_06.revDateRel = t_07.rDate ) ) AND ( t_06.rlsName = 'F' ) ) ORDER BY t_07.rDate DESC ;
  2. NOTE - 2019/2/11-06:16:34.553 UTC - PC6476.04052.01.xxx.00171 - ===>Took 3.884 seconds to execute that SQL (returning 374 rows) - Teamcenter.POM at D:\workdir\tc10171a01x_win64\src\foundation\pom\eim\eim_enquire.cxx(5722)
  3. Subtree Cost: Est.IO: Est.Cpu: Est.Rows Statement Text:
  4. ____________________________________________________________________________________
  5. 1.94917965 0.0000 0.0000 1 WITH cte_000000000A110690_17 AS (SELECT t_03.puid AS revPuid, t_04.pdate_released AS revDateRel, t_03.ritems_tagu AS myItem, t_04.puid AS rlsPuid, t_04.pname AS rlsName FROM PWORKSPACEOBJECT t_01 , PRELEASE_STATUS_LIST t_02 , PITEMREVISION t_03 , PRELEASESTATUS t_04,#PRefbindtag3 WHERE ( ( ( ( ( t
  6. 1.94917965 0.0113 0.0001 1 |--Sort(DISTINCT ORDER BY:([Expr1014] DESC, [t_03].[puid] ASC, [t_04].[puid] ASC))
  7. 1.93781829 0.0000 0.0000 1 |--Nested Loops(Inner Join, OUTER REFERENCES:([t_03].[puid]) OPTIMIZED)
  8. 1.93453050 0.0000 0.0000 1 |--Nested Loops(Inner Join, OUTER REFERENCES:([t_03].[puid], [t_04].[puid]))
  9. 1.93124330 0.0000 0.0000 1 | |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1014]))
  10. 1.92793834 0.0000 0.0000 1 | | |--Nested Loops(Inner Join, OUTER REFERENCES:([t_03].[ritems_tagu]))
  11. 1.92465055 0.0000 0.0278 1 | | | |--Hash Match(Inner Join, HASH:([t_03].[ritems_tagu])=([tempdb].[dbo].[#PRefbindtag3].[puid]), RESIDUAL:([tempdb].[dbo].[#PRefbindtag3].[puid]=[TCEUT01].[dbo].[PITEMREVISION].[ritems_tagu] as [t_03].[ritems_tagu]))
  12. 1.88915813 0.0000 0.0278 72 | | | | |--Hash Match(Aggregate, HASH:([t_03].[ritems_tagu]), RESIDUAL:([TCEUT01].[dbo].[PITEMREVISION].[ritems_tagu] as [t_03].[ritems_tagu] = [TCEUT01].[dbo].[PITEMREVISION].[ritems_tagu] as [t_03].[ritems_tagu]) DEFINE:([Expr1014]=MAX([TCEUT01].[dbo].[PRELEASESTATUS].[pd
  13. 1.86138546 0.0000 0.0052 1252 | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([t_03].[puid], [Expr1019]) OPTIMIZED WITH UNORDERED PREFETCH)
  14. 1.43269575 0.0000 0.0060 1252 | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([t_02].[pvalu_0], [Expr1018]) WITH UNORDERED PREFETCH)
  15. 0.94276148 0.0000 0.0060 1434 | | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([t_03].[puid], [Expr1017]) WITH UNORDERED PREFETCH)
  16. 0.45287722 0.0000 0.0060 1433 | | | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([tempdb].[dbo].[#PRefbindtag3].[puid], [Expr1016]) WITH UNORDERED PREFETCH)
  17. 0.00767276 0.0061 0.0016 1298 | | | | | | | | |--Table Scan(OBJECT:([tempdb].[dbo].[#PRefbindtag3]))
  18. 0.43921626 0.0031 0.0002 1 | | | | | | | | |--Index Seek(OBJECT:([TCEUT01].[dbo].[PITEMREVISION].[ENM_PIPITEMREVISION_0] AS [t_03]), SEEK:([t_03].[ritems_tagu]=[tempdb].[dbo].[#PRefbindtag3].[puid]) ORDERED FORWARD)
  19. 0.48389134 0.0031 0.0002 1 | | | | | | | |--Clustered Index Seek(OBJECT:([TCEUT01].[dbo].[PRELEASE_STATUS_LIST].[PIPRELEASE_STATUS] AS [t_02]), SEEK:([t_02].[puid]=[TCEUT01].[dbo].[PITEMREVISION].[puid] as [t_03].[puid]) ORDERED FORWARD)
  20. 0.48394138 0.0031 0.0002 1 | | | | | | |--Index Seek(OBJECT:([TCEUT01].[dbo].[PRELEASESTATUS].[PIPRELEASESTATU_0] AS [t_04]), SEEK:([t_04].[puid]=[TCEUT01].[dbo].[PRELEASE_STATUS_LIST].[pvalu_0] as [t_02].[pvalu_0] AND [t_04].[pname]='F' AND [t_04].[pdate_released] <= '2019-02-11 06:16:21.
  21. 0.42285517 0.0031 0.0002 1 | | | | | |--Clustered Index Seek(OBJECT:([TCEUT01].[dbo].[PWORKSPACEOBJECT].[PIPWORKSPACEOBJEC] AS [t_01]), SEEK:([t_01].[puid]=[TCEUT01].[dbo].[PITEMREVISION].[puid] as [t_03].[puid]), WHERE:([TCEUT01].[dbo].[PWORKSPACEOBJECT].[pactive_seq] as [t_01].[pactive_seq
  22. 0.00767276 0.0061 0.0016 1298 | | | | |--Table Scan(OBJECT:([tempdb].[dbo].[#PRefbindtag3]))
  23. 0.00328322 0.0031 0.0002 1 | | | |--Index Seek(OBJECT:([TCEUT01].[dbo].[PITEMREVISION].[ENM_PIPITEMREVISION_0] AS [t_03]), SEEK:([t_03].[ritems_tagu]=[TCEUT01].[dbo].[PITEMREVISION].[ritems_tagu] as [t_03].[ritems_tagu]) ORDERED FORWARD)
  24. 0.00329973 0.0031 0.0002 1 | | |--Index Seek(OBJECT:([TCEUT01].[dbo].[PRELEASESTATUS].[ix_PRELEASESTATUS_1] AS [t_04]), SEEK:([t_04].[pname]='F' AND [t_04].[pdate_released]=[Expr1014]), WHERE:([TCEUT01].[dbo].[PRELEASESTATUS].[pdate_released] as [t_04].[pdate_released]<='2019-02-11 06:16:21.000') ORDERED
  25. 0.00328310 0.0031 0.0002 1 | |--Index Seek(OBJECT:([TCEUT01].[dbo].[PRELEASE_STATUS_LIST].[PIPRELEASE_STAT_0] AS [t_02]), SEEK:([t_02].[pvalu_0]=[TCEUT01].[dbo].[PRELEASESTATUS].[puid] as [t_04].[puid] AND [t_02].[puid]=[TCEUT01].[dbo].[PITEMREVISION].[puid] as [t_03].[puid]) ORDERED FORWARD)
  26. 0.00328310 0.0031 0.0002 1 |--Clustered Index Seek(OBJECT:([TCEUT01].[dbo].[PWORKSPACEOBJECT].[PIPWORKSPACEOBJEC] AS [t_01]), SEEK:([t_01].[puid]=[TCEUT01].[dbo].[PITEMREVISION].[puid] as [t_03].[puid]), WHERE:([TCEUT01].[dbo].[PWORKSPACEOBJECT].[pactive_seq] as [t_01].[pactive_seq]<>(0)) ORDERED FORWARD)
  27.  
  28. NOTE - 2019/2/11-06:16:34.569 UTC - PC6476.04052.01.xxx.00171 - That SQL took a long time to execute -- set TC_SLOW_SQL to -1.0 to suppress this analysis - Teamcenter.POM at D:\workdir\tc10171a01x_win64\src\foundation\pom\eim\eim_enquire.cxx(5801)
  29. err=0 rows=374 3.884 secs;
  30. 4 seconds to POM DB x-act
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement