| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Wellington Fan | Date: | October 8 2010 4:51pm |
| Subject: | Federated Tables versus Views | ||
| View as plain text | |||
Hello All,
What should I consider when trying to choose between a Federated table and a
View when I have one table's data that I'd like to be available in other
databases on the same host.
My view definition would be something like:
CREATE
[some options]
VIEW
[this_db].[this_view] AS
SELECT
[some_db].[some_table].*
FROM
[some_db].[some_table].*
Are there performance gains to be had, one against the other? Security
concerns? Replication gotchas?
Thanks!
| Thread | ||
|---|---|---|
| • Federated Tables versus Views | Wellington Fan | 8 Oct |
| • RE: Federated Tables versus Views | Gavin Towey | 8 Oct |
