Re: analyze script

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Mon, 14 Apr 2003 19:35:23 +0100
Message-ID: <3e9c697c_1@mk-nntp-1.news.uk.worldonline.com>

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA7038CB708_at_lnewton.leeds.lfs.co.uk... <snip>
> if you are running on Unix then set up a cron job as follows :
<snip>
> You could, if you so desired, set this up
> as a DBMS_JOB and let the database run it periodically.
< snip good advice about avoiding unnecessary stats gathering>

Norman,

Other things being equal, I'd go for Option 2. Personally I can see no advantages (and some disadvantages) in setting this up as a cron job.

Regards,
Paul Received on Mon Apr 14 2003 - 13:35:23 CDT