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!

Reply via email to