|
Doubt on Functioning of Query
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?
|