Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

table size and performance improvement

supersenAug 6 2021

HI all

Still people think query from large table will take more time and if we delete some unwanted data table size will be reduced so it occupies less memory and performance will be good.
is it really true
I heard from blog though we reduce the size of the table , rows are moved to different datablocks and performance may degrade.
Please add your thoughts. we have reduced the tablesize from 20gb to 15 gb recently
we are using 19c now

This post has been answered by Mustafa KALAYCI on Aug 10 2021
Jump to Answer
Comments
Post Details
Added on Aug 6 2021
3 comments
1,565 views