|< < 17 > >|
Schema: create table t( k int primary key, x int, y int );
create table t( k int primary key, x int, y int );
Consider this plan: Project( TableScan(t), [k, x])
Project( TableScan(t), [k, x])
We know there won't be duplicates, because the projection columns include the primary key.