| 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)...) |