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