Refresh secordary indx of ods

[Former Member]

Hello

I created secondary index on ods. Now its looks like that its not updated. How its possible to refresh primary and secondary index on ods?

[Former Member · Accepted solution]

for index related issues you can use txn db20

[Former Member · Accepted solution]

for should I put into New sample size?

i put 10<p> (10%) and system tell me its a wrong value???

IO cant proceed further

[edwin_harpino]

hi,

you can click 'create' (blank page icon).

no need specify %.

to refresh all tables statistics, you can put / on table,

and click 'global...' something.

hope this helps.

[edwin_harpino]

hi A,

try DB20.

hope this helps.