SHARE
TWEET

Untitled

a guest Feb 11th, 2019 77 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top