Database Reference
In-Depth Information
Figure 8.39
Query federation member metadata.
USE FEDERATION ROOT WITH RESET
GO
SELECT * FROM sys.federation_member_distributions
11. Enter the above code in the New Query editor, highlight the code, and click the
Run
button on the ribbon. he query result is shown in Figure 8.39 where the information
about the two federation members is listed.
hrough the above steps, you have learned how to create a federation. In that federation,
a federated table is created and is split into two partitions. Queries of the federated table can
be controlled by the distribution ids. By changing the range of the distribution ids, one is
able to select the rows on a speciic federation member. he metadata about the federation
members can be viewed by the database administrator.
8.5 Summary
his chapter covers the concepts and hands-on practice about views, indexes, and federations.
hese programming units are used for improving scalability and performance.
his chapter gives detailed descriptions of the beneits of views to support database applica-
tions. he hands-on activity of views demonstrates how to create, modify, and drop views. It also
shows how the modiication of a view impacts the underlying table.
he concepts of indexes are also discussed in this chapter. he index hands-on activity illus-
trates that the index use can signiicantly improve the performance of a cloud-based database.
Federations are important to databases on the cloud due to the size limit on each individual
database. For business use, each SQL database is limited to 50 GB in size. For other usage, an
