Ususally when creating tables in development we are doing something like

create table abc as
select * from def;

The create index

create index ind_abc on abc(column1);

Sometimes the files are extending but usually they are not.