Collect stats on unique primary index failing

Database
Enthusiast

Collect stats on unique primary index failing

Hi all!

One of the statements is collecting stats on a index which ia unique primary index made up of 5 columns.
This statement is placed immediatelt after an insert is made to the table.

This collect stats did run finr for a few days,but now suddenly it does not run and gives a spool space error. It has around 0.3 million recs now.
Any suggetsions on how to fix this?

Thanks!
2 REPLIES
Enthusiast

Re: Collect stats on unique primary index failing

What is the current max spool for the user submitting the collect stats command? Are there multiple sessions associated with this user when the stats are being collected? (Spool is shared across all sessions.)

Are you collecting full stats or a sample? The best practice recommendation for TD12+ is to collect a sample of stats for UPI's. It may or may not help in your situation based on the answers to the questions above.
Enthusiast

Re: Collect stats on unique primary index failing

Not sure about max spool. And i am using the collect stats on index statement. ?Shouldn't this collect the full stats?