Database Statistics to improve performance

[rajarshi_muhuri]

I had skipped the creation of database statistics after the import stage during ECC installation . I have installed PI 7.1 and ECC 6.0 SR3 as MCOD installation. My installation is on 64bit windows 2003 server, ORACLE 10 DB and unicode kernel.

Would it be okay if I did the database statistics creation , now that my installation is finished and both PI 7.1 and ECC 6.0 is working correctly ?

i would be calling it via command line

brconnect.exe -u / -c -o summary -f stats -o SAPSR4 -t all -p 8 -f nocasc

my schema for the ECC is SAPSR4.

[former_member204746 · Accepted solution]

yes, you can do this right now.

-p is at 8, so, just do this off hours or when nobody is using this as it may impair performance while this job runs.

good luck.