Update statistics
This is a multi-part message in MIME format.
------=_NextPart_000_005F_01C08068.1A7BF7E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
I have something that worries me a bit. I wrote a 4gl program that will run
the update statistics on my system. The old update statistics cron used to
only update statistics on
- tables
- indexed columns
The new program will also update statistics on the non-indexed columns.
What worries me is, to keep this information I must need more space right ?
How much more space do I need ? Is it something to worry about - I tested
the program on our development server and it was ok, I just want to make
double sure that when I run this on my live system, that it doesn't bring
the system down.
Dirk
Dirk Moolman
Database Administrator
Reach Technologies
"Bravery is the capacity to perform properly even when scared half to
death."
- General Omar Bradley
------=_NextPart_000_005F_01C08068.1A7BF7E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D572442007-17012001>I have =
something=20
that worries me a bit. I wrote a 4gl program that will run the =
update=20
statistics on my system. The old update statistics cron used to =
only=20
update statistics on </SPAN></FONT></DIV><DIV><FONT face=3DArial size=3D2><SPAN class=3D572442007-17012001>-=20
tables</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D572442007-17012001>- =
indexed=20
columns</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D572442007-17012001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D572442007-17012001>The =
new program will=20
also update statistics on the non-indexed columns.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D572442007-17012001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D572442007-17012001>What =
worries me is,=20
to keep this information I must need more space right ? How =
much=20
more space do I need ? Is it something to worry about - I tested =
the=20
program on our development server and it was ok, I just want to make =
double sure=20
that when I run this on my live system, that it doesn't bring the system =
down.</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2><FONT face=3DArial><SPAN=20
class=3D572442007-17012001>Dirk</SPAN><BR><BR></FONT></FONT></DIV>
<P><FONT face=3D"Comic Sans MS" size=3D2>Dirk Moolman</FONT> <BR><FONT=20
face=3D"Comic Sans MS" size=3D2>Database Administrator</FONT> <BR><FONT=20
face=3D"Comic Sans MS" size=3D2>Reach Technologies</FONT> </P><BR>
<P><FONT face=3D"Comic Sans MS" size=3D2>"Bravery is the capacity to =
perform=20
properly even when scared half to death."</FONT> <BR><FONT face=3D"Comic =
Sans MS"=20
size=3D2>- General Omar Bradley</FONT> </P>
<DIV> </DIV></BODY></HTML>
------=_NextPart_000_005F_01C08068.1A7BF7E0--