-
Does Table partioning really improves the performance of DataBase?
Thanks in Advance
-
-
-
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.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|