創建Partition Table前要先思考什麼? - SQL Server

Posted by: bart30508 | in SQL Server | 8 months, 4 weeks ago |

基本上都是由效能以及維護作為出發進行思考。

是否需要創建Partition?

  1. 如果你是因為效能上的考量,那你可能要注意是否Partition Coulmn是你所想要使用的Column,當然就算不是也有一定幫助(檔案系統的分流).
  2. 如果是為了資料的管理,切了絕對會更好管理與維護。

如何決定Partition Column?

  1. 如果是效能考量,那思考會與Index想法一樣
  2. 如果是維護考量, 常用的就是Datetime(因為資料通常是一層一層疊上來的)

Partition要切多大塊?

A rule of thumb for a partitioned table suggests that partitions should be around 10m rows in size.

參考來源:

Is table partitioning improving performance? Is it worth it?
Using partitioning is only going to help your query performance if the partitioning scheme is built to serve your…dba.stackexchange.com
SQL Server - Partitioned Tables vs. Clustered Index?
Let's assume you have one massive table with three columns as shown below: [id] INT NOT NULL, [date] SMALLDATETIME NOT…stackoverflow.com
https://blogs.lessthandot.com/index.php/datamgmt/dbadmin/sql-server-filegroups-the-what/

Currently unrated
 or 

Subscribe

* indicates required

Recent Posts

Archive

2022
2021

Categories

Apache 1

Data Science 2

Dbfit 1

Design Pattern 1

Devops 3

DigitalOcean 1

Django 1

English 3

Excel 5

Flask 3

Git 1

HackMD 1

Heroku 1

Html/Css 1

Linux 4

Machine Learning 2

Manufacture 1

Mezzanine 18

Oracle 1

Postgresql 7

PowerBI 4

Powershell 4

Python 21

SEO 2

SQL Server 51

SQLite 1

Windows 1

database 8

work-experience 1

其他 1

自我成長 1

資料工程 1

Tags

SEO(1) Github(2) Title Tag(2) ML(1) 李宏毅(1) SQL Server(18) Tempdb(1) SSMS(1) Windows(1) 自我成長(2) Excel(1) python Flask(1) python(5) Flask(2)

Authors

bart30508 (146)

Feeds

RSS / Atom

創建Partition Table前要先思考什麼? - SQL Server

© COPYRIGHT 2011-2022. Max的文藝復興. ALL RIGHT RESERVED.