If you run an UPDATE statement on the partitioning column of a partitioned view and the UPDATE statement includes an inner join to another table, a scan of each partition table may be performed. This problem occurs although a useful index exists on each table. Depending on the size of each partition
Read More - Register for Free Membership
