educative.io

Educative

Partitioning in sql server

So, the solution says we use db like sql server. However in the data partitioning section we partition by movieid . So are we talking about primary key in data partitioning in sql server? But we can’t control what type of partitioning sql server uses correct?

Hi Sandeep,

Thank you for reaching out to us and giving your feedback.

We’ll get back to you soon!

If you have any further concerns/questions/comments, please let us know.

Followup to this question- can you give an example of a RDBMS that out of the box can partition across multiple machines? My understanding is that RDBMS can only partition on same machine

Hi @Steven
Here is a link to answer your question.