Table partioning

[irehman]

Does Table partioning really improves the performance of DataBase?

Thanks in Advance

[marist89]

Yes

[marist89]

No

[marist89]

Partitioning is not a silver bullet for performance. It really depends on what types of queries are used and what type of partitioning you employ.

If you are doing a lot of Full Table Scans on large subsets of data, range partitioning may improve your performance.

If you are doing a lot of FTS for all the data, hash partitioned tables may help performance if they are distributed properly on multiple devices.

If you access your table via index every time, no you will not see a significant increase in performance.