Posted by Danny on 11/25/05 14:34

You also will want to change the view to an partitioned view. Is will allow
queries against the constraint to only run against the table it needs and
not both.


"Madhivanan" <madhivanan2001@gmail.com> wrote in message
news:1132841546.627137.101470@g44g2000cwa.googlegroups.com...
> UNION ALL is more efficient that UNION as UNION will unnecessarily
> select Distinct and Order the data
>
> Madhivanan
>

[Back to original message]