872515 wrote:Are you referring to num_rows = 24976? Column num_rows is statistical column it is populated when you gather table stats. So all num_rows = 24976 indicates is you collected stats on a single partition table with num_rows = 24976. Then you exchanged partition. That doesn't update stats automatically. So you end up with stale stats. Now you need to collect stats after and you'll see correct values.
TP_ORDINV_MAX 24976 MAXVALUE
Pay attention to the last record
tags on the lines before and after your code to preserve formatting. See the FAQ for details.