StmtText                                                                                                                                                                                                                                                                                      StmtId      NodeId      Parent      PhysicalOp                     LogicalOp                      Argument                                                                                                                            DefinedValues                                EstimateRows             EstimateIO               EstimateCPU              AvgRowSize  TotalSubtreeCost         OutputList                                                  Warnings Type                           Parallel EstimateExecutions       
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- ----------- ------------------------------ ------------------------------ ----------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------- ------------------------ ------------------------ ------------------------ ----------- ------------------------ ----------------------------------------------------------- -------- ------------------------------ -------- ------------------------ 
SELECT TOP 1 a.au_lname AS 'AuthorLastName', a.au_fname AS 'AuthorFirstName', 
t.title AS 'Title', t.pubdate AS 'PublicationDate'
FROM dbo.Authors a
INNER JOIN dbo.TitleAuthor ta
	ON a.au_id = ta.au_id
INNER JOIN dbo.Titles t
	ON ta.title_id = t.title_id
WHERE a.state = 'CA'    5           1           0           NULL                           NULL                           1                                                                                                                                   NULL                                         1.0                      NULL                     NULL                     NULL        2.0580066E-2             NULL                                                        NULL     SELECT                         0        NULL
  |--Top(1)                                                                                                                                                                                                                                                                                   5           2           1           Top                            Top                            NULL                                                                                                                                NULL                                         1.0                      0.0                      0.0000001                93          2.0580066E-2             [a].[au_lname], [a].[au_fname], [t].[title], [t].[pubdate]  NULL     PLAN_ROW                       0        1.0
       |--Nested Loops(Inner Join, OUTER REFERENCES:([ta].[title_id]))                                                                                                                                                                                                                        5           4           2           Nested Loops                   Inner Join                     OUTER REFERENCES:([ta].[title_id])                                                                                                  NULL                                         1.0                      0.0                      8.2500002E-5             200         2.0579867E-2             [a].[au_lname], [a].[au_fname], [t].[title], [t].[pubdate]  NULL     PLAN_ROW                       0        1.0
            |--Nested Loops(Inner Join, OUTER REFERENCES:([ta].[au_id]))                                                                                                                                                                                                                      5           5           4           Nested Loops                   Inner Join                     OUTER REFERENCES:([ta].[au_id])                                                                                                     NULL                                         1.0                      0.0                      0.0001045                123         1.4167584E-2             [a].[au_lname], [a].[au_fname], [ta].[title_id]             NULL     PLAN_ROW                       0        1.0
            |    |--Index Scan(OBJECT:([pubs].[dbo].[titleauthor].[titleidind] AS [ta]))                                                                                                                                                                                                      5           6           5           Index Scan                     Index Scan                     OBJECT:([pubs].[dbo].[titleauthor].[titleidind] AS [ta])                                                                            [ta].[au_id], [ta].[title_id]                2.0                      3.8556417E-3             0.000053                 54          7.7112834E-3             [ta].[au_id], [ta].[title_id]                               NULL     PLAN_ROW                       0        1.0
            |    |--Clustered Index Seek(OBJECT:([pubs].[dbo].[authors].[UPKCL_auidind] AS [a]), SEEK:([a].[au_id]=[ta].[au_id]),  WHERE:([a].[state]='CA') ORDERED FORWARD)                                                                                                                  5           7           5           Clustered Index Seek           Clustered Index Seek           OBJECT:([pubs].[dbo].[authors].[UPKCL_auidind] AS [a]), SEEK:([a].[au_id]=[ta].[au_id]),  WHERE:([a].[state]='CA') ORDERED FORWARD  [a].[state], [a].[au_lname], [a].[au_fname]  1.0                      6.3284999E-3             7.9603E-5                78          6.7126756E-3             [a].[state], [a].[au_lname], [a].[au_fname]                 NULL     PLAN_ROW                       0        3.0
            |--Clustered Index Seek(OBJECT:([pubs].[dbo].[titles].[UPKCL_titleidind] AS [t]), SEEK:([t].[title_id]=[ta].[title_id]) ORDERED FORWARD)                                                                                                                                          5           8           4           Clustered Index Seek           Clustered Index Seek           OBJECT:([pubs].[dbo].[titles].[UPKCL_titleidind] AS [t]), SEEK:([t].[title_id]=[ta].[title_id]) ORDERED FORWARD                     [t].[title], [t].[pubdate]                   1.0                      6.3284999E-3             7.9603E-5                85          6.4081028E-3             [t].[title], [t].[pubdate]                                  NULL     PLAN_ROW                       0        1.0

(7 row(s) affected)