Update statistics 
Author Message
 Update statistics
Hi,
I am DBA for a SAP account running informix 7.31. I need some more info or
White pages on Informix optimizer and update statistics process.

Thanks in Advance
Natraj



Sun, 06 Jun 2004 13:37:50 GMT
 Update statistics

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C18895.110C7BE0
Content-Type: text/plain

Performance guide 7.3 chapter 10 covers update statistics.  You can read the
manuals at
http://www.informix.com/documentation/

Regards,
Bill

Quote:
> -----Original Message-----

> Sent:      Wednesday, December 19, 2001 12:38 AM

> Subject:   Update statistics

> Hi,
> I am DBA for a SAP account running informix 7.31. I need some more info or
> White pages on Informix optimizer and update statistics process.

> Thanks in Advance
> Natraj

------_=_NextPart_001_01C18895.110C7BE0
Content-Type: text/html
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=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: Update statistics</TITLE>
</HEAD>
<BODY>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Performance guide =
7.3 chapter 10 covers update statistics.&nbsp; You can read the manuals =
at</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A =
HREF=3D"http://www.informix.com/documentation/" =
TARGET=3D"_blank">http://www.informix.com/documentation/</A></FONT>
</P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Regards,</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Bill</FONT>
</P>
<UL>

Quote:
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =
SIZE=3D1 FACE=3D"Arial">Natraj Hegde =

<BR><B><FONT SIZE=3D1 FACE=3D"Arial">Sent:&nbsp;&nbsp;</FONT></B> <FONT =
SIZE=3D1 FACE=3D"Arial">Wednesday, December 19, 2001 12:38 AM</FONT>
<BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT SIZE=3D1 =

<BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT>=
</B> <FONT SIZE=3D1 FACE=3D"Arial">Update statistics</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Hi,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">I am DBA for a SAP account running =
informix 7.31. I need some more info or</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">White pages on Informix optimizer and =
update statistics process.</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks in Advance</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Natraj</FONT>
</P>
<BR>
</UL>
</BODY>
</HTML>
------_=_NextPart_001_01C18895.110C7BE0--



Sun, 06 Jun 2004 21:57:16 GMT
 Update statistics

Quote:

> Hi,
> I am DBA for a SAP account running informix 7.31. I need some more info or
> White pages on Informix optimizer and update statistics process.

The Performance Guide Informix manual is the definitive statement on
how to use the update statistics statement to best advantage and on
how the optimizer works.  BTW you can download my dostats utility
which implements the recommended procedure from the Performance Guide
exactly and provides many options for modifying its behavior.

Dostats is contained in the package utils2_ak available for download
from the IIUG Software Repository.

Art S. Kagel



Mon, 07 Jun 2004 00:00:56 GMT
 Update statistics

With SAP you will need to run the update stats through sapdba. It can be run
from the command line, and there are many different options. Check out oss
notes for your version. You can also contact me off-list to discuss it
further.

Quote:
-----Original Message-----

Sent: Tuesday, December 18, 2001 9:38 PM

Subject: Update statistics

Hi,
I am DBA for a SAP account running informix 7.31. I need some more info or
White pages on Informix optimizer and update statistics process.

Thanks in Advance
Natraj



Mon, 07 Jun 2004 01:10:28 GMT
 Update statistics
Generally, the 7.3 performance guide provides good information on
Informix optimizer. I remember seeing some information about update
statistics in the migration guide. If you have specific questions,
please post it here.

- Naresh

Quote:

> Hi,
> I am DBA for a SAP account running informix 7.31. I need some more info or
> White pages on Informix optimizer and update statistics process.

> Thanks in Advance
> Natraj



Mon, 07 Jun 2004 07:29:23 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Performance Issues with UPDATE STATISTICS WITH FULLSCAN on _WA_Sys auto statistics

2. ANNOUNCE: Another update statistics utility - latest update

3. An update statistics program - updated version for you

4. Update statistics

5. updating statistics and recompiling stored procedures

6. Update Statistics Error

7. auto update statistics

8. Auto Create/Update Statistics and insert performance in SQL 7.0

9. UPDATE STATISTICS

10. Using the UPDATE STATISTICS statement

11. Updating statistics


 
Powered by phpBB® Forum Software