#眉標=SQL Server 2008、Parallel、WorkLoad #副標=實作資料庫系統調校(3) #大標=實測SQL2008平行處理 #作者=文/圖 陳泓翔 =============<反灰>==================== ALTER TABLE dbo.nabk_p2 ADD CONSTRAINT PK_nabk_p2 PRIMARY KEY (SYS_SERIAL); Go ================================= =============<反灰>==================== CREATE NONCLUSTERED INDEX idx1_nabk_p2 on dbo.nabk_p2(POLICY_NO, RECE_NO); ================================= =============<反灰>==================== CREATE NONCLUSTERED INDEX idx1_nabk_p1 on dbo.nabk_p1(POLICY_NO, RECE_NO) with(MAXDOP=2); ================================= =============<反灰>==================== select * from dbo.nabk_p2 t2 join dbo.NABK_p1 t1 on t1.sys_serial= t2.sys_serial and t1.POLICY_NO=t2.POLICY_NO and t2.sys_serial between 5071001 and 6271001 order by 2 ; =================================