I'm curious about the scope of partitioning in the MSSQL program

아름 정 0 Reputation points
2023-04-25T06:32:53.7066667+00:00

Hello
I am a student studying DB such as Oracle and MSSQL. I understand that MSSQL supports Range Partitioning. I would like to ask if MSSQL can use Hash, List, Composite, Round Robin, and Interval Partitioning

SQL Server | Other
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,441 Reputation points
    2023-04-25T07:33:00.2233333+00:00

    Hash, List, Composite, Round Robin, and Interval Partitioning

    Not really one of them. Partitioning is done by the table data, e.g. one could create a partition per year, base on a date column. See Partitioned tables and indexes

    0 comments No comments

  2. Anonymous
    2023-04-26T05:53:35.2633333+00:00

    Hi @아름 정

    In addition to the above answer, you can also refer to these two posts.

    https://www.sqlshack.com/partitions-in-sql-server/

    https://www.sqlshack.com/database-table-partitioning-sql-server/

    Best regards,

    Percy Tang


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.