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