Most voted "database-partitioning" questions
*Database partitioning* (partitioning) is the act of separating a table into different parts, usually to improve performance or availability
Learn more…3 questions
Sort by count of
-
3
votes0
answers515
viewsWhat should I worry about when creating a Partitioned Table in SQL Server?
I was suggested to partition the main table of my system to improve the performance of some queries. The dev who made the suggestion suggested using the information from ano registry registration to…
-
0
votes0
answers244
viewsPartitioning MYSQL tables
Good night to you all. I have a question regarding tables in mysql. Assuming the following scenario. I have a MYSQL INNODB table with PK ID INT UNSIGNED. ( 4 billion records approx) 1 º If by chance…
-
0
votes1
answer373
viewsRemove partition from table
Using the mysql documentation, I created the partition based on a year field. ALTER TABLE minhatabela PARTITION BY HASH (ano_referencia) PARTITIONS 10 To make a possible rollback, how I would drop…