Analyze tables+ind
From: timo <timo.talja_at_luukku.com>
Date: Wed, 19 Nov 2008 08:38:15 GMT
Message-ID: <XfQUk.60$5q2.44@read4.inet.fi>
Date: Wed, 19 Nov 2008 08:38:15 GMT
Message-ID: <XfQUk.60$5q2.44@read4.inet.fi>
Hi,
I'd like to analyze one schema's all tables and indexes every night - should
I implement a PL/SQL-procedure for this and add it to Database
Control/Scheduler Jobs ? - there seems to some "gather stats"-jobs already
but those are "smart-ones" and this one schema is vital an stats must in
up-to-date.
BR,
Timo
Received on Wed Nov 19 2008 - 02:38:15 CST