VIEW vs. TABLE performance

[DZube]

Background:
(2) database ::
a) Source tables
b) Fact (derived) tables

Challenge:
In order to provide the users of the Fact database access
to the underlying source tables without requiring them to
understand that there is a separate database (and the need
to include additional qualifiers in the table reference in
their SELECT statements)

Solution?:
In the Fact database,
CREATE VIEW [Base Table1] AS
Select * From [Source database].dbo.[Base Table1]

Is there any performance degradation due to referencing
this rather simple view in a SELECT statement vs.
referencing the base table directly?

/.dz

[Adam Machanic]

Performance should be identical.

"DZube" <anon...@discussions.microsoft.com> wrote in message
news:036701c3a876$20dbaa20$a101...@phx.gbl...