|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!
|• Federated Tables versus Views||Wellington Fan||8 Oct|
|• RE: Federated Tables versus Views||Gavin Towey||8 Oct|