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>


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

Original text of this message