Skip to Content
0
Former Member
Feb 15, 2011 at 05:40 AM

Regarding UPDATE STATISTICS

28 Views

Hi,

Greetings!

I am required to make a comprehensive documentation regarding difference between

UPDATE STATISTICS functions of SQL SERVER and INFORMIX.

To start with, I have the following question:

(I found many documents on the internet, they are too much technical.)

At this moment, I would like to understand the concept well. Hence I need a brief explanation

as to what functions are really carried out broadly when the SQL SERVER performs the

"UPDATE STATISTICS".

Brief Explanation needed, but needs to list all the functions carried out.

Also, If u r well-versed with Informix, I would like u to answer the same question for Informix also.

Actually I need the output like the following:

SQL Server :

============

1. Updates Statistics on tables / Indexes.

2.

3.

Informix:

========

1. Updates Statistics on tables / Indexes.

2. Compiling stored procedures.

3.

Thanks & Best Regards,

Raghunahth L