Hi Experts,

I am new in using Informix.

Would like to know what are the performance settings for the database in usage with Baan. I read that I must run UPDATE STATISTICS to improve performance.
Can someone give me some advice on how to run and when to run UPDATE STATISTICS.

Thanks and regards,

hi Kingsto88

To update statistics, you can use UPDATE STATISTICS statement. SQL Server 7.0 can update distribution statistics automatically, so in most cases it is not necessary to update distribution statistics manually and you can rely on SQL Server decisions to update distribution statistics.


This is the syntax (from SQL Server Books Online):

UPDATE STATISTICS table
[
index
| (statistics_name[,...n])
]
[ WITH
[
[FULLSCAN]
| SAMPLE number {PERCENT | ROWS}]
]
[[,] [ALL | COLUMNS | INDEX]
[[,] NORECOMPUTE]
]
This is the example to update distribution statistics for the aunmind index from the authors table in the pubs database:

USE pubs
GO
UPDATE STATISTICS authors aunmind
GO

For more information, see: UPDATE STATISTICS (T-SQL)

1. If you set to not automatically recompute distribution statistics, then you should manually run UPDATE STATISTICS statement periodically (when a large amount of data in an indexed column has been added, changed, or deleted).

2. After running TRUNCATE TABLE statement, the distribution statistics will also be deleted, so if you set to not automatically recompute statistics, then after adding new data, you should manually run UPDATE STATISTICS statement to recreate distribution statistics.

Viplov

how to run it directly from baan server...

will users be affect?

i am new in baan and informix...