SHARE
TWEET

Untitled

a guest Feb 11th, 2019 74 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. WITH cte_000000000B91F4D0_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-10 17:15:42', 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_000000000B91F4D0_17 t_06 , (SELECT  MAX ( t_05.revDateRel ) AS rDate, t_05.myItem AS dtItem FROM cte_000000000B91F4D0_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/10-17:18:35.192 UTC - PC3550.10336.01.XXX.00090 - ===>Took 137.142 seconds to execute that SQL (returning 76 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.32190299          0.0000  0.0000         1    WITH cte_000000000B91F4D0_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.32190299         0.0113  0.0001         1      |--Sort(DISTINCT ORDER BY:([Expr1014] DESC, [t_03].[puid] ASC, [t_04].[puid] ASC))
  7.    1.31054175        0.0000  0.0000         1           |--Nested Loops(Inner Join, OUTER REFERENCES:([t_03].[puid]) OPTIMIZED)
  8.     1.30725384       0.0000  0.0000         1                |--Nested Loops(Inner Join, OUTER REFERENCES:([t_03].[puid], [t_04].[puid]))
  9.      1.30396664      0.0000  0.0000         1                |    |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1014]))
  10.       1.30066180     0.0000  0.0000         1                |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([t_03].[ritems_tagu]))
  11.        1.29737389    0.0000  0.0220         1                |    |    |    |--Hash Match(Inner Join, HASH:([t_03].[ritems_tagu])=([tempdb].[dbo].[#PRefbindtag3].[puid]), RESIDUAL:([tempdb].[dbo].[#PRefbindtag3].[puid]=[TCEUP01].[dbo].[PITEMREVISION].[ritems_tagu] as [t_03].[ritems_tagu]))
  12.         1.27095151   0.0000  0.0003        70                |    |    |    |    |--Stream Aggregate(GROUP BY:([t_03].[ritems_tagu]) DEFINE:([Expr1014]=MAX([TCEUP01].[dbo].[PRELEASESTATUS].[pdate_released] as [t_04].[pdate_released])))
  13.          1.27068985  0.0000  0.0016       378                |    |    |    |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([t_03].[puid], [Expr1018]) WITH ORDERED PREFETCH)
  14.           0.98885566 0.0000  0.0019       378                |    |    |    |    |         |--Nested Loops(Inner Join, OUTER REFERENCES:([t_02].[pvalu_0], [Expr1017]) WITH ORDERED PREFETCH)
  15.           0.65494531 0.0000  0.0019       449                |    |    |    |    |         |    |--Nested Loops(Inner Join, OUTER REFERENCES:([t_03].[puid], [Expr1016]) WITH ORDERED PREFETCH)
  16.           0.32131171 0.0000  0.0019       448                |    |    |    |    |         |    |    |--Nested Loops(Inner Join, OUTER REFERENCES:([tempdb].[dbo].[#PRefbindtag3].[puid], [Expr1015]) WITH ORDERED PREFETCH)
  17.           0.02131891 0.0113  0.0056       406                |    |    |    |    |         |    |    |    |--Sort(ORDER BY:([tempdb].[dbo].[#PRefbindtag3].[puid] ASC))
  18.           0.00446934 0.0039  0.0006       406                |    |    |    |    |         |    |    |    |    |--Table Scan(OBJECT:([tempdb].[dbo].[#PRefbindtag3]))
  19.           0.29812005 0.0031  0.0002         1                |    |    |    |    |         |    |    |    |--Index Seek(OBJECT:([TCEUP01].[dbo].[PITEMREVISION].[PIPITEMREVISION_0] AS [t_03]), SEEK:([t_03].[ritems_tagu]=[tempdb].[dbo].[#PRefbindtag3].[puid]) ORDERED FORWARD)
  20.           0.33175850 0.0031  0.0002         1                |    |    |    |    |         |    |    |--Clustered Index Seek(OBJECT:([TCEUP01].[dbo].[PRELEASE_STATUS_LIST].[PIPRELEASE_STATUS] AS [t_02]), SEEK:([t_02].[puid]=[TCEUP01].[dbo].[PITEMREVISION].[puid] as [t_03].[puid]) ORDERED FORWARD)
  21.           0.33203524 0.0031  0.0002         1                |    |    |    |    |         |    |--Index Seek(OBJECT:([TCEUP01].[dbo].[PRELEASESTATUS].[PIPRELEASESTATU_0] AS [t_04]), SEEK:([t_04].[puid]=[TCEUP01].[dbo].[PRELEASE_STATUS_LIST].[pvalu_0] as [t_02].[pvalu_0] AND [t_04].[pname]='F' AND [t_04].[pdate_released] <= '2019-02-10 17:15:42.
  22.           0.28007069 0.0031  0.0002         1                |    |    |    |    |         |--Clustered Index Seek(OBJECT:([TCEUP01].[dbo].[PWORKSPACEOBJECT].[PIPWORKSPACEOBJEC] AS [t_01]), SEEK:([t_01].[puid]=[TCEUP01].[dbo].[PITEMREVISION].[puid] as [t_03].[puid]),  WHERE:([TCEUP01].[dbo].[PWORKSPACEOBJECT].[pactive_seq] as [t_01].[pactive_seq
  23.         0.00446934   0.0039  0.0006       406                |    |    |    |    |--Table Scan(OBJECT:([tempdb].[dbo].[#PRefbindtag3]))
  24.        0.00328322    0.0031  0.0002         1                |    |    |    |--Index Seek(OBJECT:([TCEUP01].[dbo].[PITEMREVISION].[PIPITEMREVISION_0] AS [t_03]), SEEK:([t_03].[ritems_tagu]=[TCEUP01].[dbo].[PITEMREVISION].[ritems_tagu] as [t_03].[ritems_tagu]) ORDERED FORWARD)
  25.       0.00329969     0.0031  0.0002         1                |    |    |--Index Seek(OBJECT:([TCEUP01].[dbo].[PRELEASESTATUS].[EN_PIPRELEASESTATUS_1] AS [t_04]), SEEK:([t_04].[pname]='F' AND [t_04].[pdate_released]=[Expr1014]),  WHERE:([TCEUP01].[dbo].[PRELEASESTATUS].[pdate_released] as [t_04].[pdate_released]<='2019-02-10 17:15:42.000') ORDERE
  26.      0.00328310      0.0031  0.0002         1                |    |--Index Seek(OBJECT:([TCEUP01].[dbo].[PRELEASE_STATUS_LIST].[PIPRELEASE_STAT_0] AS [t_02]), SEEK:([t_02].[pvalu_0]=[TCEUP01].[dbo].[PRELEASESTATUS].[puid] as [t_04].[puid] AND [t_02].[puid]=[TCEUP01].[dbo].[PITEMREVISION].[puid] as [t_03].[puid]) ORDERED FORWARD)
  27.     0.00328318       0.0031  0.0002         1                |--Clustered Index Seek(OBJECT:([TCEUP01].[dbo].[PWORKSPACEOBJECT].[PIPWORKSPACEOBJEC] AS [t_01]), SEEK:([t_01].[puid]=[TCEUP01].[dbo].[PITEMREVISION].[puid] as [t_03].[puid]),  WHERE:([TCEUP01].[dbo].[PWORKSPACEOBJECT].[pactive_seq] as [t_01].[pactive_seq]<>(0)) ORDERED FORWARD)
  28.  
  29. NOTE  - 2019/2/10-17:18:35.208 UTC - PC3550.10336.01.XXX.00090 - 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)
  30. 137 seconds to POM DB x-act
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top