Collect stats

Database

Collect stats

Collect Statistics On tab2_new  From tab1_old

3 REPLIES
WAQ
N/A

Re: Collect stats

What is the issue?

WAQ
N/A

Re: Collect stats

What is the issue?

Re: Collect stats

If you want all Stats on the new table, then you can do the following:

CREATE TABLE tab2_new AS tab1_old with data and stats;

It copies bot data and Stats to the new table