#眉標=SQL Server 2008、Indexed Views、Data Warehouse
#副標=實作資料庫系統調校(2)
#大標=實作可提高資料庫效能的Indexed Views 
#作者=文／圖	陳泓翔



=============<反灰>====================
Select t1.POLICY_NO,t1.BILL_ADDRESS_IND from dbo.NABK t1 join dbo.podt t2 on t1.POLICY_NO=t2.POLICY_NO;
=============<END>====================




=============<反灰>====================
CREATE VIEW dbo.IVNABK WITH SCHEMABINDING
AS
select t1.POLICY_NO,t1.BILL_ADDRESS_IND from dbo.NABK t1 join dbo.podt t2 on t1.POLICY_NO=t2.POLICY_NO;
GO
CREATE unique CLUSTERED INDEX inx_uc_POLICY_NO ON dbo.IVNABK (policy_no);
GO
=============<END>====================




=============<反灰>====================
Select * into dbo.duppodt from dbo.podt
=============<END>====================



=============<反灰>====================
CREATE VIEW dbo.IVPODT WITH SCHEMABINDING
AS
select POLICY_NO ,
POLICY_TYPE ,
…略
GO
=============<END>====================