I have a huge table in a Data Warehouse, if I partition the table my month will it improve the performance.
Thanks in Advance
Printable View
I have a huge table in a Data Warehouse, if I partition the table my month will it improve the performance.
Thanks in Advance
it will if your queries are based on time
of course partition improves your query performance. but before partitioning consider all of your scenarios. i mean, what type of parition will be preferrable for you. u can even put your partitions on different tablespaces and even there indexes seperate.
all the best