analyse_database
From: Steve Salvemini <steve.salvemini_at_adelaide.edu.au>
Date: 2000/07/03
Message-ID: <39605344.DDCCDDD2_at_adelaide.edu.au>#1/1
Date: 2000/07/03
Message-ID: <39605344.DDCCDDD2_at_adelaide.edu.au>#1/1
[Quoted] Is the DBMS_UTILITY.analyze_database something that should be run regularly, ie on a weekly basis, or for new DB refreshes, and does it update SYS tables as well?
(Following this, should all SYS tables have stats on them?)
I guess the analyse_schema is only really for specific tasks, such as a [Quoted] need only to update the stats for a particular schema.
Thanks Folks Received on Mon Jul 03 2000 - 00:00:00 CEST