Unicode conv. Update Database Stats - DB20

[ThomasKjelsrud]

Hi all

I am on SAP ERP2005 on Windows 2003 server 64 bit and MSSQL 2005. I am doing a unicode conversion, and as a prerequisite it is recommended that I update database statistics. I have tried to do the DB export using SAPInst tools, but the export fails on table STXH. A colleague told me to update the stats for this table.. DB20 was the obvious tool, but this is not supported for SQL 2005.. How can I proceed to update statistics?

Thanks!

Regards,

Thomas

[rolfc_weber · Accepted solution]

Hi,

Use transaction DB02 => Detailed Analysis.

Select your table, and on the following screen you can select "Update statistics".

Regards

Rolf