Collect stats

Database
Junior Supporter

Collect stats

Collect Statistics On tab2_new  From tab1_old

3 REPLIES
WAQ
Enthusiast

Re: Collect stats

What is the issue?

WAQ
Enthusiast

Re: Collect stats

What is the issue?

Enthusiast

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