Questions tagged [partitioned-view]

I am trying to get partitioned views to work, and still see query optimizer scanning both tables. Here is my script: CREATE TABLE A(DataDate [date] NOT NULL CHECK(datepart(yy, DataDate) <= 2010)) CREATE TABLE B(DataDate [date] NOT NULL…