FIGURE 3: Statistics profile output for SELECT *WHERE customerid = 'ALFKI' statement against a distributed partitioned view
Rows Executes StmtText
1 1 SELECT * FROM [Customers] WHERE [customerid]=@1
1 1 |--Concatenation
1 1 |--Filter(WHERE:(STARTUP EXPR(Convert([@1])<='FZZZZ' AND Convert([@1])>='AAAAA')))
1 1 | |--Clustered Index Seek(OBJECT:([testdb].[dbo].[CustomersAF].[PK_CustomersAF])...
0 1 |--Filter(WHERE:(STARTUP EXPR(Convert([@1])<='PZZZZ' AND Convert([@1])>='GAAAA')))
0 0 | |--Remote Query(SOURCE:(Node2)...)
0 1 |--Filter(WHERE:(STARTUP EXPR(Convert([@1])<='ZZZZZ' AND Convert([@1])>='QAAAA')))
0 0 |--Remote Query(SOURCE:(Node3)...)