Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM (
- SELECT row_number() OVER(ORDER BY DateCreated DESC )+(CASE WHEN 15*FLOOR((row_number() OVER(ORDER BY DateCreated DESC )-1)/10) <301 THEN 15*floor((row_number() OVER(ORDER BY DateCreated DESC )-1)/10) ELSE 301 END) as rownum,
- 1 1 0 NULL NULL 1 NULL 25 NULL NULL NULL 2.970234 NULL NULL SELECT 0 NULL
- |--Stream Aggregate(GROUP BY:([Union1056], [Union1057], [Union1058], [Union1059], [Union1060], [Union1061], [Union1062], [Union1063], [Union1064], [Union1065], [Union1066], [Union1067], [Union1068], [Union1069], [Union1070], [Union1071], [Union1072], [Un 1 2 1 Stream Aggregate Aggregate GROUP BY:([Union1056], [Union1057], [Union1058], [Union1059], [Union1060], [Union1061], [Union1062], [Union1063], [Union1064], [Union1065], [Union1066], [Union1067], [Union1068], [Union1069], [Union1070], [Union1071], [Union1072], [Union1073], [Union1074], NULL 25 0 2.5E-05 7172 2.970234 [Union1056], [Union1057], [Union1058], [Union1059], [Union1060], [Union1061], [Union1062], [Union1063], [Union1064], [Union1065], [Union1066], [Union1067], [Union1068], [Union1069], [Union1070], [Union1071], [Union1072], [Union1073], [Union1074], [Union107 NULL PLAN_ROW 0 1
- |--Sort(ORDER BY:([Union1056] ASC, [Union1057] ASC, [Union1058] ASC, [Union1059] ASC, [Union1060] ASC, [Union1061] ASC, [Union1062] ASC, [Union1063] ASC, [Union1064] ASC, [Union1065] ASC, [Union1066] ASC, [Union1067] ASC, [Union1068] ASC, [Union1069 1 3 2 Sort Sort ORDER BY:([Union1056] ASC, [Union1057] ASC, [Union1058] ASC, [Union1059] ASC, [Union1060] ASC, [Union1061] ASC, [Union1062] ASC, [Union1063] ASC, [Union1064] ASC, [Union1065] ASC, [Union1066] ASC, [Union1067] ASC, [Union1068] ASC, [Union1069] ASC, [Union10 NULL 25 0.01126126 0.0002882824 7172 2.970209 [Union1056], [Union1057], [Union1058], [Union1059], [Union1060], [Union1061], [Union1062], [Union1063], [Union1064], [Union1065], [Union1066], [Union1067], [Union1068], [Union1069], [Union1070], [Union1071], [Union1072], [Union1073], [Union1074], [Union107 NULL PLAN_ROW 0 1
- |--Concatenation 1 4 3 Concatenation Concatenation NULL [Union1056] = ([Expr1027], [Expr1055]), [Union1057] = ([Ad].[ID], [Ad].[ID]), [Union1058] = ([Ad].[AdTitle], [Ad].[AdTitle]), [Union1059] = ([Ad].[FreeDescription], [Ad].[FreeDescription]), [Union1060] = ([Ad].[DescriptionJob], [Ad].[DescriptionJob]), [Uni 25 0 2.5E-06 7172 2.95866 [Union1056], [Union1057], [Union1058], [Union1059], [Union1060], [Union1061], [Union1062], [Union1063], [Union1064], [Union1065], [Union1066], [Union1067], [Union1068], [Union1069], [Union1070], [Union1071], [Union1072], [Union1073], [Union1074], [Union107 NULL PLAN_ROW 0 1
- |--Compute Scalar(DEFINE:([Expr1027]=[Expr1024]+CASE WHEN (15)*floor(([Expr1025]-(1))/(10))<(301) THEN (15)*floor(([Expr1026]-(1))/(10)) ELSE (301) END)) 1 5 4 Compute Scalar Compute Scalar DEFINE:([Expr1027]=[Expr1024]+CASE WHEN (15)*floor(([Expr1025]-(1))/(10))<(301) THEN (15)*floor(([Expr1026]-(1))/(10)) ELSE (301) END) [Expr1027]=[Expr1024]+CASE WHEN (15)*floor(([Expr1025]-(1))/(10))<(301) THEN (15)*floor(([Expr1026]-(1))/(10)) ELSE (301) END 10 0 1E-06 24425 1.198372 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | |--Sequence Project(DEFINE:([Expr1024]=row_number, [Expr1025]=row_number, [Expr1026]=row_number)) 1 6 5 Sequence Project Compute Scalar DEFINE:([Expr1024]=row_number, [Expr1025]=row_number, [Expr1026]=row_number) [Expr1024]=row_number, [Expr1025]=row_number, [Expr1026]=row_number 10 0 1E-06 24441 1.19837 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | |--Compute Scalar(DEFINE:([Expr1102]=(1))) 1 7 6 Compute Scalar Compute Scalar DEFINE:([Expr1102]=(1)) [Expr1102]=(1) 10 0 2E-07 24441 1.198371 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | |--Segment 1 8 7 Segment Segment NULL NULL 10 0 2E-07 24441 1.198371 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | |--Top(TOP EXPRESSION:((10))) 1 9 8 Top Top TOP EXPRESSION:((10)) NULL 10 0 1E-06 24417 1.19837 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | |--Sort(DISTINCT ORDER BY:([Ad].[DateCreated] DESC, [Ad].[ID] ASC, [Expr1023] ASC, [L1].[CodeValue] ASC, [Img1].[Path] ASC, [Img2].[Path] ASC)) 1 10 9 Sort Distinct Sort DISTINCT ORDER BY:([Ad].[DateCreated] DESC, [Ad].[ID] ASC, [Expr1023] ASC, [L1].[CodeValue] ASC, [Img1].[Path] ASC, [Img2].[Path] ASC) NULL 10 0.01126126 0.000266074 24417 1.198369 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | |--Compute Scalar(DEFINE:([Expr1022]=(0), [Expr1023]=isnull([masterdb].[dbo].[tblAdJobOffer].[AdCity] as [Ad].[AdCity],[masterdb].[dbo].[tblCantons].[Name] as [Cant].[Name]))) 1 11 10 Compute Scalar Compute Scalar DEFINE:([Expr1022]=(0), [Expr1023]=isnull([masterdb].[dbo].[tblAdJobOffer].[AdCity] as [Ad].[AdCity],[masterdb].[dbo].[tblCantons].[Name] as [Cant].[Name])) [Expr1022]=(0), [Expr1023]=isnull([masterdb].[dbo].[tblAdJobOffer].[AdCity] as [Ad].[AdCity],[masterdb].[dbo].[tblCantons].[Name] as [Cant].[Name]) 20.31063 0 2.031063E-06 28431 1.186841 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | |--Nested Loops(Inner Join, PASSTHRU:([IsBaseRow1019] IS NULL), OUTER REFERENCES:([Img1].[ID])) 1 12 11 Nested Loops Inner Join PASSTHRU:([IsBaseRow1019] IS NULL), OUTER REFERENCES:([Img1].[ID]) NULL 20.31063 0 8.489843E-05 28436 1.186839 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Ad].[ID])) 1 13 12 Nested Loops Left Outer Join OUTER REFERENCES:([Ad].[ID]) NULL 20.31063 0 8.489843E-05 28424 1.128184 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | | |--Nested Loops(Left Outer Join, WHERE:([masterdb].[dbo].[tblSourceImages2].[ImageFK] as [tsi].[ImageFK]=[masterdb].[dbo].[tblImages2].[ID] as [Img2].[ID])) 1 14 13 Nested Loops Left Outer Join WHERE:([masterdb].[dbo].[tblSourceImages2].[ImageFK] as [tsi].[ImageFK]=[masterdb].[dbo].[tblImages2].[ID] as [Img2].[ID]) NULL 20.18898 0 0.0002531698 28410 1.067511 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | | | |--Nested Loops(Left Outer Join, WHERE:([masterdb].[dbo].[tblAdJobOffer].[SourceFK] as [Ad].[SourceFK]=[masterdb].[dbo].[tblSourceImages2].[SourceFK] as [tsi].[SourceFK])) 1 15 14 Nested Loops Left Outer Join WHERE:([masterdb].[dbo].[tblAdJobOffer].[SourceFK] as [Ad].[SourceFK]=[masterdb].[dbo].[tblSourceImages2].[SourceFK] as [tsi].[SourceFK]) NULL 20.18898 0 0.003375597 28405 1.062426 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | | | | |--Nested Loops(Left Outer Join, WHERE:([masterdb].[dbo].[LangStrings].[CodeId] as [L1].[CodeId]=[masterdb].[dbo].[tblAdJobOffer].[WorkTypeFK] as [Ad].[WorkTypeFK])) 1 16 15 Nested Loops Left Outer Join WHERE:([masterdb].[dbo].[LangStrings].[CodeId] as [L1].[CodeId]=[masterdb].[dbo].[tblAdJobOffer].[WorkTypeFK] as [Ad].[WorkTypeFK]) NULL 10.09449 0 4.219496E-05 28392 1.053897 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | | | | | |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Ad].[CantonFK])) 1 17 16 Nested Loops Left Outer Join OUTER REFERENCES:([Ad].[CantonFK]) NULL 10.09449 0 4.219496E-05 24377 1.046551 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | | | | | | |--Nested Loops(Left Semi Join, OUTER REFERENCES:([Ad].[ID])) 1 18 17 Nested Loops Left Semi Join OUTER REFERENCES:([Ad].[ID]) NULL 10.09449 0 4.219496E-05 24368 1.041788 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | | | | | | | |--Filter(WHERE:(([masterdb].[dbo].[tblAdJobOffer].[WorkTime] as [Ad].[WorkTime] IS NULL OR [masterdb].[dbo].[tblAdJobOffer].[WorkTime] as [Ad].[WorkTime]>=(0) AND [jobc 1 19 18 Filter Filter WHERE:(([masterdb].[dbo].[tblAdJobOffer].[WorkTime] as [Ad].[WorkTime] IS NULL OR [masterdb].[dbo].[tblAdJobOffer].[WorkTime] as [Ad].[WorkTime]>=(0) AND [masterdb].[dbo].[tblAdJobOffer].[WorkTime] as [Ad].[WorkTime]<=(100) AND ([masterdb].[dbo].[tblAdJobO NULL 10.09449 0 3.714772E-05 24368 0.5287474 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | | | | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([Ad].[ID])) 1 20 19 Nested Loops Inner Join OUTER REFERENCES:([Ad].[ID]) NULL 10.09449 0 4.219496E-05 24368 0.5287102 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | | | | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([RA].[AdID])) 1 21 20 Nested Loops Inner Join OUTER REFERENCES:([RA].[AdID]) NULL 10.09449 0 0.000359096 22 0.4986536 [Ad].[ID], [Ad].[AdStatus] NULL PLAN_ROW 0 1
- | | | | | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([RA].[ID])) 1 22 21 Nested Loops Inner Join OUTER REFERENCES:([RA].[ID]) NULL 85.90814 0 0.000359096 20 0.2799081 [RA].[AdID] NULL PLAN_ROW 0 1
- | | | | | | | | | | |--Index Seek(OBJECT:([masterdb].[dbo].[tblResAds].[IX_BaseTableFK_ActiveState_enddate] AS [RA]), SEEK:([RA].[BaseTableFK]=(30) AND [RA].[ActiveState 1 23 22 Index Seek Index Seek OBJECT:([masterdb].[dbo].[tblResAds].[IX_BaseTableFK_ActiveState_enddate] AS [RA]), SEEK:([RA].[BaseTableFK]=(30) AND [RA].[ActiveState]=(1) AND [RA].[enddate] >= getdate()) ORDERED FORWARD [RA].[ID] 85.90814 0.003125 0.0002514989 11 0.003376499 [RA].[ID] NULL PLAN_ROW 0 1
- | | | | | | | | | | |--Clustered Index Seek(OBJECT:([masterdb].[dbo].[tblResAds].[PK_tblResAds] AS [RA]), SEEK:([RA].[ID]=[masterdb].[dbo].[tblResAds].[ID] as [RA].[ID]) 1 25 22 Clustered Index Seek Clustered Index Seek OBJECT:([masterdb].[dbo].[tblResAds].[PK_tblResAds] AS [RA]), SEEK:([RA].[ID]=[masterdb].[dbo].[tblResAds].[ID] as [RA].[ID]) LOOKUP ORDERED FORWARD [RA].[AdID] 1 0.003125 0.0001581 20 0.2761725 [RA].[AdID] NULL PLAN_ROW 0 85.90814
- | | | | | | | | | |--Index Seek(OBJECT:([masterdb].[dbo].[tblAdJobOffer].[IX_tblAdJobOffer_AdStatus] AS [Ad]), SEEK:([Ad].[AdStatus]=(3) AND [Ad].[ID]=[masterdb].[dbo].[tbl 1 29 21 Index Seek Index Seek OBJECT:([masterdb].[dbo].[tblAdJobOffer].[IX_tblAdJobOffer_AdStatus] AS [Ad]), SEEK:([Ad].[AdStatus]=(3) AND [Ad].[ID]=[masterdb].[dbo].[tblResAds].[AdID] as [RA].[AdID]) ORDERED FORWARD [Ad].[ID], [Ad].[AdStatus] 1 0.003125 0.0001581 22 0.2183864 [Ad].[ID], [Ad].[AdStatus] NULL PLAN_ROW 0 85.90814
- | | | | | | | | |--Clustered Index Seek(OBJECT:([masterdb].[dbo].[tblAdJobOffer].[PK_tblAdJobOffer] AS [Ad]), SEEK:([Ad].[ID]=[masterdb].[dbo].[tblAdJobOffer].[ID] as [Ad].[ID 1 31 20 Clustered Index Seek Clustered Index Seek OBJECT:([masterdb].[dbo].[tblAdJobOffer].[PK_tblAdJobOffer] AS [Ad]), SEEK:([Ad].[ID]=[masterdb].[dbo].[tblAdJobOffer].[ID] as [Ad].[ID]) LOOKUP ORDERED FORWARD [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad].[CompanyName], [Ad].[Conta 1 0.003125 0.0001581 24688 0.03001446 [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad].[CompanyName], [Ad].[Conta NULL PLAN_ROW 0 10.09449
- | | | | | | | |--Filter(WHERE:([masterdb].[dbo].[tblAdJobOffer].[ID] as [Ad].[ID] = [Full-text Search Engine].[KEY])) 1 92 18 Filter Filter WHERE:([masterdb].[dbo].[tblAdJobOffer].[ID] as [Ad].[ID] = [Full-text Search Engine].[KEY]) NULL 1 0 0.00566448 9 0.5129988 NULL NULL PLAN_ROW 0 10.09449
- | | | | | | | |--Table Spool 1 93 92 Table Spool Lazy Spool NULL NULL 11801 0.01 0.00222428 20 0.4558187 [Full-text Search Engine].[KEY] NULL PLAN_ROW 0 10.09449
- | | | | | | | |--Remote Scan(OBJECT:(FREETEXT)) 1 94 93 Remote Scan Remote Scan OBJECT:(FREETEXT) NULL 11801 0 0.4233667 20 0.4233667 [Full-text Search Engine].[KEY] NULL PLAN_ROW 0 1
- | | | | | | |--Clustered Index Seek(OBJECT:([masterdb].[dbo].[tblCantons].[PK_tblCantons] AS [Cant]), SEEK:([Cant].[ID]=[masterdb].[dbo].[tblAdJobOffer].[CantonFK] as [Ad].[CantonFK]) OR 1 96 17 Clustered Index Seek Clustered Index Seek OBJECT:([masterdb].[dbo].[tblCantons].[PK_tblCantons] AS [Cant]), SEEK:([Cant].[ID]=[masterdb].[dbo].[tblAdJobOffer].[CantonFK] as [Ad].[CantonFK]) ORDERED FORWARD [Cant].[Name] 1 0.003125 0.0001581 18 0.004720938 [Cant].[Name] NULL PLAN_ROW 0 10.09449
- | | | | | |--Table Scan(OBJECT:([masterdb].[dbo].[LangStrings] AS [L1]), WHERE:([masterdb].[dbo].[LangStrings].[CodeType] as [L1].[CodeType]=N'WorkType' AND [masterdb].[dbo].[LangStrings].[ 1 97 16 Table Scan Table Scan OBJECT:([masterdb].[dbo].[LangStrings] AS [L1]), WHERE:([masterdb].[dbo].[LangStrings].[CodeType] as [L1].[CodeType]=N'WorkType' AND [masterdb].[dbo].[LangStrings].[Language] as [L1].[Language]=N'de') [L1].[CodeId], [L1].[CodeValue] 1 0.003944241 0.0002589 4051 0.005843787 [L1].[CodeId], [L1].[CodeValue] NULL PLAN_ROW 0 10.09449
- | | | | |--Table Scan(OBJECT:([masterdb].[dbo].[tblSourceImages2] AS [tsi])) 1 99 15 Table Scan Table Scan OBJECT:([masterdb].[dbo].[tblSourceImages2] AS [tsi]) [tsi].[SourceFK], [tsi].[ImageFK] 80 0.003944241 0.0001665 33 0.004911056 [tsi].[SourceFK], [tsi].[ImageFK] NULL PLAN_ROW 0 10.09449
- | | | |--Clustered Index Scan(OBJECT:([masterdb].[dbo].[tblImages2].[PK_tblImages2] AS [Img2]), WHERE:([masterdb].[dbo].[tblImages2].[ImageTypeFK] as [Img2].[ImageTypeFK]=(61))) 1 101 14 Clustered Index Scan Clustered Index Scan OBJECT:([masterdb].[dbo].[tblImages2].[PK_tblImages2] AS [Img2]), WHERE:([masterdb].[dbo].[tblImages2].[ImageTypeFK] as [Img2].[ImageTypeFK]=(61)) [Img2].[ID], [Img2].[Path] 3 0.0032035 0.0001313 44 0.004347978 [Img2].[ID], [Img2].[Path] NULL PLAN_ROW 0 20.18898
- | | |--Index Seek(OBJECT:([masterdb].[dbo].[tblImages].[IX_AdID_ImageTypeFK] AS [Img1]), SEEK:([Img1].[AdID]=[masterdb].[dbo].[tblAdJobOffer].[ID] as [Ad].[ID] AND [Img1].[ImageTypeFK]=(61)) ORDERED 1 103 13 Index Seek Index Seek OBJECT:([masterdb].[dbo].[tblImages].[IX_AdID_ImageTypeFK] AS [Img1]), SEEK:([Img1].[AdID]=[masterdb].[dbo].[tblAdJobOffer].[ID] as [Ad].[ID] AND [Img1].[ImageTypeFK]=(61)) ORDERED FORWARD [IsBaseRow1019], [Img1].[ID] 1.006026 0.003125 0.0001581066 21 0.06058843 [IsBaseRow1019], [Img1].[ID] NULL PLAN_ROW 0 20.18898
- | |--Clustered Index Seek(OBJECT:([masterdb].[dbo].[tblImages].[PK_tblImages] AS [Img1]), SEEK:([Img1].[ID]=[masterdb].[dbo].[tblImages].[ID] as [Img1].[ID]) LOOKUP ORDERED FORWARD) 1 105 12 Clustered Index Seek Clustered Index Seek OBJECT:([masterdb].[dbo].[tblImages].[PK_tblImages] AS [Img1]), SEEK:([Img1].[ID]=[masterdb].[dbo].[tblImages].[ID] as [Img1].[ID]) LOOKUP ORDERED FORWARD [Img1].[Path] 1 0.003125 0.0001581 141 0.0585641 [Img1].[Path] NULL PLAN_ROW 0 20.31063
- |--Compute Scalar(DEFINE:([Expr1055]=[Expr1052]+CASE WHEN (10)*floor((1)+([Expr1053]-(1))/(15))<(24) THEN (10)*floor((1)+([Expr1054]-(1))/(15)) ELSE (24) END)) 1 128 4 Compute Scalar Compute Scalar DEFINE:([Expr1055]=[Expr1052]+CASE WHEN (10)*floor((1)+([Expr1053]-(1))/(15))<(24) THEN (10)*floor((1)+([Expr1054]-(1))/(15)) ELSE (24) END) [Expr1055]=[Expr1052]+CASE WHEN (10)*floor((1)+([Expr1053]-(1))/(15))<(24) THEN (10)*floor((1)+([Expr1054]-(1))/(15)) ELSE (24) END 15 0 1.5E-06 24425 1.760286 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- |--Sequence Project(DEFINE:([Expr1052]=row_number, [Expr1053]=row_number, [Expr1054]=row_number)) 1 129 128 Sequence Project Compute Scalar DEFINE:([Expr1052]=row_number, [Expr1053]=row_number, [Expr1054]=row_number) [Expr1052]=row_number, [Expr1053]=row_number, [Expr1054]=row_number 15 0 1.5E-06 24441 1.760284 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- |--Compute Scalar(DEFINE:([Expr1104]=(1))) 1 130 129 Compute Scalar Compute Scalar DEFINE:([Expr1104]=(1)) [Expr1104]=(1) 15 0 3E-07 24441 1.760285 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- |--Segment 1 131 130 Segment Segment NULL NULL 15 0 3E-07 24441 1.760285 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- |--Top(TOP EXPRESSION:((15))) 1 132 131 Top Top TOP EXPRESSION:((15)) NULL 15 0 1.5E-06 24417 1.760283 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- |--Sort(DISTINCT ORDER BY:([Ad].[DateCreated] DESC, [Ad].[ID] ASC, [Expr1051] ASC, [L1].[CodeValue] ASC, [Img1].[Path] ASC, [Img2].[Path] ASC)) 1 133 132 Sort Distinct Sort DISTINCT ORDER BY:([Ad].[DateCreated] DESC, [Ad].[ID] ASC, [Expr1051] ASC, [L1].[CodeValue] ASC, [Img1].[Path] ASC, [Img2].[Path] ASC) NULL 15 0.01126126 0.000886297 24417 1.760281 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- |--Compute Scalar(DEFINE:([Expr1050]=(1), [Expr1051]=isnull([masterdb].[dbo].[tblAdJobOffer].[AdCity] as [Ad].[AdCity],[masterdb].[dbo].[tblCantons].[Name] as [Cant].[Name]))) 1 134 133 Compute Scalar Compute Scalar DEFINE:([Expr1050]=(1), [Expr1051]=isnull([masterdb].[dbo].[tblAdJobOffer].[AdCity] as [Ad].[AdCity],[masterdb].[dbo].[tblCantons].[Name] as [Cant].[Name])) [Expr1050]=(1), [Expr1051]=isnull([masterdb].[dbo].[tblAdJobOffer].[AdCity] as [Ad].[AdCity],[masterdb].[dbo].[tblCantons].[Name] as [Cant].[Name]) 77.4238 0 7.74238E-06 28431 1.748134 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- |--Nested Loops(Inner Join, PASSTHRU:([IsBaseRow1047] IS NULL), OUTER REFERENCES:([Img1].[ID])) 1 135 134 Nested Loops Inner Join PASSTHRU:([IsBaseRow1047] IS NULL), OUTER REFERENCES:([Img1].[ID]) NULL 77.4238 0 0.0003236315 28436 1.748126 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Ad].[ID])) 1 136 135 Nested Loops Left Outer Join OUTER REFERENCES:([Ad].[ID]) NULL 77.4238 0 0.0003236315 28424 1.500722 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | |--Nested Loops(Left Outer Join, WHERE:([masterdb].[dbo].[tblSourceImages2].[ImageFK] as [tsi].[ImageFK]=[masterdb].[dbo].[tblImages2].[ID] as [Img2].[ID])) 1 137 136 Nested Loops Left Outer Join WHERE:([masterdb].[dbo].[tblSourceImages2].[ImageFK] as [tsi].[ImageFK]=[masterdb].[dbo].[tblImages2].[ID] as [Img2].[ID]) NULL 77.4238 0 0.0009708944 28410 1.259677 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | | |--Hash Match(Right Outer Join, HASH:([tsi].[SourceFK])=([Ad].[SourceFK]), RESIDUAL:([masterdb].[dbo].[tblAdJobOffer].[SourceFK] as [Ad].[SourceFK]=[masterdb].[dbo].[tblSourceImages2].[Sour 1 138 137 Hash Match Right Outer Join HASH:([tsi].[SourceFK])=([Ad].[SourceFK]), RESIDUAL:([masterdb].[dbo].[tblAdJobOffer].[SourceFK] as [Ad].[SourceFK]=[masterdb].[dbo].[tblSourceImages2].[SourceFK] as [tsi].[SourceFK]) NULL 77.4238 0 0.02052325 28405 1.249483 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | | | |--Table Scan(OBJECT:([masterdb].[dbo].[tblSourceImages2] AS [tsi])) 1 139 138 Table Scan Table Scan OBJECT:([masterdb].[dbo].[tblSourceImages2] AS [tsi]) [tsi].[SourceFK], [tsi].[ImageFK] 80 0.003865741 0.000245 33 0.004110741 [tsi].[SourceFK], [tsi].[ImageFK] NULL PLAN_ROW 0 1
- | | | |--Hash Match(Right Outer Join, HASH:([L1].[CodeId])=([Ad].[WorkTypeFK]), RESIDUAL:([masterdb].[dbo].[LangStrings].[CodeId] as [L1].[CodeId]=[masterdb].[dbo].[tblAdJobOffer].[WorkTypeF 1 140 138 Hash Match Right Outer Join HASH:([L1].[CodeId])=([Ad].[WorkTypeFK]), RESIDUAL:([masterdb].[dbo].[LangStrings].[CodeId] as [L1].[CodeId]=[masterdb].[dbo].[tblAdJobOffer].[WorkTypeFK] as [Ad].[WorkTypeFK]) NULL 76.45823 0 0.02103302 28392 1.224846 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | | | |--Table Scan(OBJECT:([masterdb].[dbo].[LangStrings] AS [L1]), WHERE:([masterdb].[dbo].[LangStrings].[CodeType] as [L1].[CodeType]=N'WorkType' AND [masterdb].[dbo].[LangStrings].[ 1 141 140 Table Scan Table Scan OBJECT:([masterdb].[dbo].[LangStrings] AS [L1]), WHERE:([masterdb].[dbo].[LangStrings].[CodeType] as [L1].[CodeType]=N'WorkType' AND [masterdb].[dbo].[LangStrings].[Language] as [L1].[Language]=N'de') [L1].[CodeId], [L1].[CodeValue] 1 0.003865741 0.0003374 4051 0.004203141 [L1].[CodeId], [L1].[CodeValue] NULL PLAN_ROW 0 1
- | | | |--Nested Loops(Left Outer Join, OUTER REFERENCES:([Ad].[CantonFK])) 1 142 140 Nested Loops Left Outer Join OUTER REFERENCES:([Ad].[CantonFK]) NULL 76.45823 0 0.0003195954 24377 1.199463 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | | | |--Hash Match(Right Semi Join, HASH:([Full-text Search Engine].[KEY])=([Ad].[ID]), RESIDUAL:([masterdb].[dbo].[tblAdJobOffer].[ID] as [Ad].[ID] = [Full-text Search Engine].[K 1 143 142 Hash Match Right Semi Join HASH:([Full-text Search Engine].[KEY])=([Ad].[ID]), RESIDUAL:([masterdb].[dbo].[tblAdJobOffer].[ID] as [Ad].[ID] = [Full-text Search Engine].[KEY]) NULL 76.45823 0 0.2460927 24368 1.18393 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | | | | |--Remote Scan(OBJECT:(FREETEXT)) 1 144 143 Remote Scan Remote Scan OBJECT:(FREETEXT) NULL 11801 0 0.4233667 20 0.4233667 [Full-text Search Engine].[KEY] NULL PLAN_ROW 0 1
- | | | | |--Filter(WHERE:(([masterdb].[dbo].[tblAdJobOffer].[WorkTime] as [Ad].[WorkTime] IS NULL OR [masterdb].[dbo].[tblAdJobOffer].[WorkTime] as [Ad].[WorkTime]>=(0) AND [jobc 1 145 143 Filter Filter WHERE:(([masterdb].[dbo].[tblAdJobOffer].[WorkTime] as [Ad].[WorkTime] IS NULL OR [masterdb].[dbo].[tblAdJobOffer].[WorkTime] as [Ad].[WorkTime]>=(0) AND [masterdb].[dbo].[tblAdJobOffer].[WorkTime] as [Ad].[WorkTime]<=(100) AND ([masterdb].[dbo].[tblAdJobO NULL 76.45823 0 0.0002813663 24368 0.5144676 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([Ad].[ID])) 1 146 145 Nested Loops Inner Join OUTER REFERENCES:([Ad].[ID]) NULL 76.45823 0 0.0003195954 24368 0.5141862 [Ad].[ID], [Ad].[AdStatus], [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad NULL PLAN_ROW 0 1
- | | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([RA].[AdID])) 1 147 146 Nested Loops Inner Join OUTER REFERENCES:([RA].[AdID]) NULL 76.45823 0 0.000359096 22 0.4986536 [Ad].[ID], [Ad].[AdStatus] NULL PLAN_ROW 0 1
- | | | | | |--Nested Loops(Inner Join, OUTER REFERENCES:([RA].[ID])) 1 148 147 Nested Loops Inner Join OUTER REFERENCES:([RA].[ID]) NULL 85.90814 0 0.000359096 20 0.2799081 [RA].[AdID] NULL PLAN_ROW 0 1
- | | | | | | |--Index Seek(OBJECT:([masterdb].[dbo].[tblResAds].[IX_BaseTableFK_ActiveState_enddate] AS [RA]), SEEK:([RA].[BaseTableFK]=(30) AND [RA].[ActiveState 1 149 148 Index Seek Index Seek OBJECT:([masterdb].[dbo].[tblResAds].[IX_BaseTableFK_ActiveState_enddate] AS [RA]), SEEK:([RA].[BaseTableFK]=(30) AND [RA].[ActiveState]=(1) AND [RA].[enddate] >= getdate()) ORDERED FORWARD [RA].[ID] 85.90814 0.003125 0.0002514989 11 0.003376499 [RA].[ID] NULL PLAN_ROW 0 1
- | | | | | | |--Clustered Index Seek(OBJECT:([masterdb].[dbo].[tblResAds].[PK_tblResAds] AS [RA]), SEEK:([RA].[ID]=[masterdb].[dbo].[tblResAds].[ID] as [RA].[ID]) 1 151 148 Clustered Index Seek Clustered Index Seek OBJECT:([masterdb].[dbo].[tblResAds].[PK_tblResAds] AS [RA]), SEEK:([RA].[ID]=[masterdb].[dbo].[tblResAds].[ID] as [RA].[ID]) LOOKUP ORDERED FORWARD [RA].[AdID] 1 0.003125 0.0001581 20 0.2761725 [RA].[AdID] NULL PLAN_ROW 0 85.90814
- | | | | | |--Index Seek(OBJECT:([masterdb].[dbo].[tblAdJobOffer].[IX_tblAdJobOffer_AdStatus] AS [Ad]), SEEK:([Ad].[AdStatus]=(3) AND [Ad].[ID]=[masterdb].[dbo].[tbl 1 155 147 Index Seek Index Seek OBJECT:([masterdb].[dbo].[tblAdJobOffer].[IX_tblAdJobOffer_AdStatus] AS [Ad]), SEEK:([Ad].[AdStatus]=(3) AND [Ad].[ID]=[masterdb].[dbo].[tblResAds].[AdID] as [RA].[AdID]) ORDERED FORWARD [Ad].[ID], [Ad].[AdStatus] 1 0.003125 0.0001581 22 0.2183864 [Ad].[ID], [Ad].[AdStatus] NULL PLAN_ROW 0 85.90814
- | | | | |--Clustered Index Seek(OBJECT:([masterdb].[dbo].[tblAdJobOffer].[PK_tblAdJobOffer] AS [Ad]), SEEK:([Ad].[ID]=[masterdb].[dbo].[tblAdJobOffer].[ID] as [Ad].[ID 1 157 146 Clustered Index Seek Clustered Index Seek OBJECT:([masterdb].[dbo].[tblAdJobOffer].[PK_tblAdJobOffer] AS [Ad]), SEEK:([Ad].[ID]=[masterdb].[dbo].[tblAdJobOffer].[ID] as [Ad].[ID]) LOOKUP ORDERED FORWARD [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad].[CompanyName], [Ad].[Conta 1 0.003125 0.0001581 24688 0.01521305 [Ad].[AdNumber], [Ad].[SourceFK], [Ad].[OnlineUserFK], [Ad].[AdTitle], [Ad].[ProfessionFK], [Ad].[PositionFK], [Ad].[BranchFK], [Ad].[WorkTypeFK], [Ad].[WorkTime], [Ad].[WorkTime2], [Ad].[WorkStart], [Ad].[DescriptionShort], [Ad].[CompanyName], [Ad].[Conta NULL PLAN_ROW 0 76.45823
- | | | |--Clustered Index Seek(OBJECT:([masterdb].[dbo].[tblCantons].[PK_tblCantons] AS [Cant]), SEEK:([Cant].[ID]=[masterdb].[dbo].[tblAdJobOffer].[CantonFK] as [Ad].[CantonFK]) OR 1 219 142 Clustered Index Seek Clustered Index Seek OBJECT:([masterdb].[dbo].[tblCantons].[PK_tblCantons] AS [Cant]), SEEK:([Cant].[ID]=[masterdb].[dbo].[tblAdJobOffer].[CantonFK] as [Ad].[CantonFK]) ORDERED FORWARD [Cant].[Name] 1 0.003125 0.0001581 18 0.01521305 [Cant].[Name] NULL PLAN_ROW 0 76.45823
- | | |--Clustered Index Scan(OBJECT:([masterdb].[dbo].[tblImages2].[PK_tblImages2] AS [Img2]), WHERE:([masterdb].[dbo].[tblImages2].[ImageTypeFK] as [Img2].[ImageTypeFK]=(61))) 1 222 137 Clustered Index Scan Clustered Index Scan OBJECT:([masterdb].[dbo].[tblImages2].[PK_tblImages2] AS [Img2]), WHERE:([masterdb].[dbo].[tblImages2].[ImageTypeFK] as [Img2].[ImageTypeFK]=(61)) [Img2].[ID], [Img2].[Path] 3 0.0032035 0.0001313 44 0.007369976 [Img2].[ID], [Img2].[Path] NULL PLAN_ROW 0 77.4238
- | |--Index Seek(OBJECT:([masterdb].[dbo].[tblImages].[IX_AdID_ImageTypeFK] AS [Img1]), SEEK:([Img1].[AdID]=[masterdb].[dbo].[tblAdJobOffer].[ID] as [Ad].[ID] AND [Img1].[ImageTypeFK]=(61)) ORDERED 1 224 136 Index Seek Index Seek OBJECT:([masterdb].[dbo].[tblImages].[IX_AdID_ImageTypeFK] AS [Img1]), SEEK:([Img1].[AdID]=[masterdb].[dbo].[tblAdJobOffer].[ID] as [Ad].[ID] AND [Img1].[ImageTypeFK]=(61)) ORDERED FORWARD [IsBaseRow1047], [Img1].[ID] 1 0.003125 0.0001581 21 0.2407213 [IsBaseRow1047], [Img1].[ID] NULL PLAN_ROW 0 77.4238
- |--Clustered Index Seek(OBJECT:([masterdb].[dbo].[tblImages].[PK_tblImages] AS [Img1]), SEEK:([Img1].[ID]=[masterdb].[dbo].[tblImages].[ID] as [Img1].[ID]) LOOKUP ORDERED FORWARD) 1 226 135 Clustered Index Seek Clustered Index Seek OBJECT:([masterdb].[dbo].[tblImages].[PK_tblImages] AS [Img1]), SEEK:([Img1].[ID]=[masterdb].[dbo].[tblImages].[ID] as [Img1].[ID]) LOOKUP ORDERED FORWARD [Img1].[Path] 1 0.003125 0.0001581 141 0.2470566 [Img1].[Path] NULL PLAN_ROW 0 77.4238
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement