Thread: SQL server partitions
06-15-04, 10:07 #1Registered User
- Join Date
- Feb 2004
Unanswered: SQL server partitions
I created 3 tables with constraints on numeric field and I created a union all view on these tables, when I select from the view specifying a condition using the constraint field the execution plan scans all the tables instead of the table that match the conditions.