Can Partition Size result in poor query performance!
Dear All,
In 10gR2, for a particular table partition the sql query's gives poor performance as compared to other partitions. I checked this partition is 5 times size of the other table partitions. Please advise if the Huge size can contribute to slowness of sql's on this partition.
Regards,
-Sunil
0