Database partitioning? What is it, why should I use it?

What is database partitioning?

What’s the advantage of using database partitioning?

When should I partition my table?

Why shouldn’t I use an index instead of partitioning?

On what can I base my database partitioning strategy?

What are the different types of partitioning?

1. Range Partitioning

2. List Partitioning

3. Hash Partitioning

4. Sub Partitioning

Multipotentialite on the loose

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store