where is the physical location of a distributed partitioned view?
I cannot understand distributed partitioned views (database scaling)
The tutorials that I've read always have this sort of image. [User]开发者_开发知识库s => [Distributed partitioned view] and from [Distributed partitioned view] there will be many arrows pointing to each individual servers.
Where exactly does the distributed partitioned view live at? Does it live in a separate server dedicated to the job?
A distributed partitioned view resides wherever you create it. Any view is always created on a particular server. "Distributed" just means a view referencing tables which happen to exist on other servers.
精彩评论