Doubt on Functioning of Query

[caradoc]

I have a table named as employee created. I have done vertical partitioning on this table and made this table into two tables. I have also created a view named as getview on the table employee. My doubt is if the data needed by me is in the first split table of the two partitions whether my view getview would fetch values querying only this or would it join both partitions and make the query. How it will function internally?

[cyrus]

Vertical partitioning is done also for the reason of achieving performance. So having done vertical partitioning on table named as employee and the view defined named as getview on the table employee would fetch values querying from whichever table it find the column occurring and would not refer both the table until the need for that occurs.