Hi,
maybe a stupid question,
with dostats -LIC the following updates are generated :
1. UPDATE STATISTICS LOW FOR TABLE cas DROP DISTRIBUTIONS;
2. UPDATE STATISTICS HIGH FOR TABLE cas (csscod);
3. UPDATE STATISTICS HIGH FOR TABLE cas ( docnid ) DISTRIBUTIONS ONLY;
4. UPDATE STATISTICS LOW FOR TABLE cas (csscod, docnid, casocc, caslin);
5. UPDATE STATISTICS LOW FOR TABLE cas (docnid);
Have update stats low for specific columns (line 4 and 5) sense after an
update stats for the whole table (line 1) ?
If not then I have to ommit the C from -LIC
Thanks,
Yves Dieltiens
------_=_NextPart_001_01C2F524.860A6090
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>update stats of columns</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hi,</FONT>
</P>
<P><FONT SIZE=3D2>maybe a stupid question,</FONT>
<BR><FONT SIZE=3D2>with dostats -LIC the following updates are =
generated :</FONT>
</P>
<P><FONT SIZE=3D2>1. UPDATE STATISTICS LOW FOR TABLE cas DROP =
DISTRIBUTIONS;</FONT>
<BR><FONT SIZE=3D2>2. UPDATE STATISTICS HIGH FOR TABLE cas =
(csscod);</FONT>
<BR><FONT SIZE=3D2>3. UPDATE STATISTICS HIGH FOR TABLE cas ( docnid ) =
DISTRIBUTIONS ONLY;</FONT>
<BR><FONT SIZE=3D2>4. UPDATE STATISTICS LOW FOR TABLE cas (csscod, =
docnid, casocc, caslin);</FONT>
<BR><FONT SIZE=3D2>5. UPDATE STATISTICS LOW FOR TABLE cas =
(docnid);</FONT>
</P>
<P><FONT SIZE=3D2>Have update stats low for specific columns (line 4 =
and 5) sense after an update stats for the whole table (line 1) =
?</FONT>
<BR><FONT SIZE=3D2>If not then I have to ommit the C from -LIC</FONT>
</P>
<P><FONT SIZE=3D2>Thanks,</FONT>
</P>
<P><FONT SIZE=3D2>Yves Dieltiens</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C2F524.860A6090--