Home » SQL Server Partitioned View vs Partition Table

SQL Server Partitioned View vs Partition Table

SQL Server Partitioned View vs Partition Table
Small Demo Code for Creating Partition Table
Another Small Demo Code for Creating Partition View
Now with below queries, we can find use of partitions in Partition Table

---------------to check the use of partitions-------------
set statistics io on
go
set showplan_text on
go
select * from Partitioned_Table
where col1 ='1521'

set statistics io off
go
set showplan_text off
go
Now with below queries, we can find use of partitions in Partition View
set statistics io on
go
set showplan_text on
go
select * from Sales_Tbl1
where Sales_TblID ='1555'

set statistics io off
go
set showplan_text off
go

I will discuss more on suitable usage for both in next blogs…………..

4 thoughts on “SQL Server Partitioned View vs Partition Table”

  1. I was looking through some of your articles on this site and I conceive this internet site is rattling instructive! Keep on putting up. Rey Nevil Cassi

Leave a Reply

Your email address will not be published. Required fields are marked *