Update statistics in Sybase 16.01

[Former Member]

Hi All,

How to run update statistics in Sybase 16.00.00.01.

Regards,

Karthik

[victoria_normand]

Hi Karthik,

That should be configured thru DBACockpit -> ATM , this document might be helpuful:

If, for a specific reason, you need to update statistics for a specific table, you may apply steps from SAP Note 1757691 - SYB: How to manually update index statistics of a table using isql as mentioned Anand.

HTH,
Regards,
Victoria.

[Former Member]

Hello Karthik/Maria,

The mentioned 1757691 has a attached Program which is used to update all the index statistics,

Please download and save at location

Drive:>Sybase/SID/run_update_index_stats.sql

Execute the command as below

isql -Usapsa -S<SID> -D<SID> -X -i run_update_index_stats.sql

The command will update all the index statistics.

For regular automated maintenance of index statistics.

Automatic update index statistics setup guide link has been provided in the same note.

Regards

Anand

[Former Member]

Hello Karthik,

Please refer following SAP note:-

1757691 - SYB: How to manually update index statistics of a table using isql

I hope this addresses your requirement.

Regards

Anand

[marcin_najs]

Hi.

You have to use UPDATE STATISTICS command.

Please review manual for: update statistics

Regards

--

Marcin Najs