如图,分区前Select * from Table 单表60万数据查询是13秒。
表分区后,Select * from Table 查询还是需要13秒,表分区对于Select * from Table 不加过滤条件是不是优化空间不大?
查看分区是成功的,
重新做过了分区索引
CREATE CLUSTERED INDEX [ClusteredIndex_on_idPartSchema_635342971076448165]
ON [dbo].[T_Output1]
(
[fidentityid]
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [idPartSchema]([fidentityid])