Re: update statistics
From: David Kulkarni <dnk61@yahoo.com>
>
>Each night we run update statistics with the following
>sql statement:
>
>update systables set npused = nrows /
>(2020/(rowsize)+4)
>where npused < 0
What's wrong with "update statistics"?
>and the result log file give us the following output:
>
>============================
>Mon Jan 24 22:30:03 EST 2000
>
>0 row(s) updated.
>
>============================
>
>I am a UNIX SYS ADMIN and have recently taken on the
>task of DBA, and have realy very little knowledge of
>this. Can anyone tell me by looking at the statements
>above if this is correct and why is the output log
>giving us 0 row(s) updated after it ran for almost 8
>hours. Our database is 26gig strong, this in on
>informix version 5.10uc5 and hp-ux version 10.20. Any
>comments and/or suggestions are welcome.
>
>David Kulkarni
>dnk61@yahoo.com
>
>
>__________________________________________________
>Do You Yahoo!?
>Talk to your friends online with Yahoo! Messenger.
>http://im.yahoo.com
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com