PSAP SID TABLESPACE UPDATE STATISTICS ADVANTAGES AND DISADVANTAGES

[Former Member]

Dear All,

Can anyone explain me if we select PSAP SID table space only for update statistics from DB13 Instead of selecting all tables for update statistics,what are the advantages and disadvantages of selecting only PSAP SID tablespace .

I will be glad if you can suggest any related sapnote or sapmaterial.

we are working on SAP ECC5 and oracle version id 9i and operating system is windows.

[Former Member]

Hi arunkumar ,

When you are updating statitics then update for all table space why for one only.After all it will increase the performance of your database.

Regards

Ashok

[markus_doehr2]

If you do that only the tables belonging to that tablespace will have current statistics. All others won´t.

Markus