noobcoder
noobcoder

Reputation: 6671

Stop automatic stats gathering on a specific table

I know how to stop automatic stats gathering for the whole database, but how would I stop it for a specific table only?

I have searched for this information a lot but there only seems to be information for stopping it for an entire database.

Upvotes: 0

Views: 247

Answers (1)

Matthew McPeak
Matthew McPeak

Reputation: 17944

Execute DBMS_STATS.LOCK_TABLE_STATS for the table.

Upvotes: 1

Related Questions