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 ViewsWellington Fan8 Oct
  • RE: Federated Tables versus ViewsGavin Towey8 Oct