Gather table stats without partition stats

From: Moustafa Ahmed <moustafa_dba_at_hotmail.com>
Date: Thu, 17 Jun 2021 18:22:58 +0000
Message-ID: <BN6PR06MB2785302C3CEFE6679DAD1BB1E10E9_at_BN6PR06MB2785.namprd06.prod.outlook.com>

Listers

1-on 19c I believe I read before that not gathering partition statics is much safer specially since 12c and we should be enough with table stats.. Is that true?

2-how can we ignite gathering partition stats for a table?

Thank you!--
http://www.freelists.org/webpage/oracle-l Received on Thu Jun 17 2021 - 20:22:58 CEST

This message: [ Message body ]
Next message: Mark W. Farnham: "RE: Original design approach to Oracle REDO Logs"
Previous message: Andrew Kerber: "sql developer, jump box, rsa"
Next in thread: Stefan Koehler: "Re: Gather table stats without partition stats"
Reply: Pap: "Re: Gather table stats without partition stats"
Reply: Stefan Koehler: "Re: Gather table stats without partition stats"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message