RE: An Update Statistics funny

#1 (**permalink**) 04-19-2008, 09:28 PM

This is a multi-part message in MIME format.

------_=_NextPart_001_01C43F07.B4D50A56
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I would assume that only most of your tables do not have indexes on =
them, which sounds a bit strange ...

=20

=20

=20

-----Original Message-----
From: owner-informix-list@iiug.org [mailto

wner-informix-list@iiug.org] =
On Behalf Of malcolm weallans
Sent: Thursday, May 20, 2004 5:42 PM
To: informix-list@iiug.org
Subject: An Update Statistics funny

=20

Every day this company runs UPDATE STATISTICS MEDIUM on the whole =
database. There are about 1700 tables in the database. But when I =
check in sysdistrib I can only find records for about 230 tables.

=20

IDS 9.30

SUSE Linux SLES 8

=20

Oh, and you've guessed it - they are cmplaining about performance.

=20

regards

=20

Malcolm

________________________________

<< ella for Spam Control >> has removed 997 Spam messages and set aside =
519 Newsletters for me
You can use it too - and it's FREE! www.ellaforspam.com=09

------_=_NextPart_001_01C43F07.B4D50A56
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">

<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">

<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color

urple;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

I would assume that only most of =
your
tables do not have indexes on them, which sounds a bit strange =
…

 

 

 

-----Original =
Message----- 
From: =
owner-informix-list@iiug.org
[mailto

wner-informix-list@iiug.org] On
Behalf Of malcolm weallans 
Sent: Thursday, May 20, =
2004 5:42
PM 
To: =
informix-list@iiug.org 
Subject: An Update =
Statistics
funny

 

<div>

Every day this company runs UPDATE STATISTICS =
MEDIUM
on the whole database.  There are about 1700 tables in the =
database. 
But when I check in sysdistrib I can only find records for about 230 =
tables.

</div>

<div>

 

</div>

<div>

IDS 9.30

</div>

<div>

SUSE Linux SLES 8

</div>

<div>

 

</div>

<div>

Oh, and you've guessed it - they are =
cmplaining about
performance.

</div>

<div>

 

</div>

<div>

regards

</div>

<div>

 

</div>

<div>

Malcolm

</div>

</div>

</body>

</html>
 <hr><table border=3D"1" cellpadding=3D"8" =
cellspacing=3D"0" bgcolor=3D"#FFFF99" bordercolor=3D"#999999"><tr><td =
align=3D"center">&lt&lt ella for Spam Control &gt&gt =
has removed 997 Spam messages and set aside =
519 Newsletters for me You can use it too - and it's =
FREE!&nbsp&nbsp<a =
href=3D"http://www.ellaforspam.com">www.ellaforspam.com</a></td></=
tr></table>=00
------_=_NextPart_001_01C43F07.B4D50A56--
sending to informix-list

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode