Hi all,

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.