Add the stats on the internal column PARTITION.
collect stats tablename column PARTITION;
Regards,
Yasir
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2008 Indexes