Creating separate schema for indexes
Posted in 1996
Hi all -
Does anyone have a utility or other solution to
this problem?
I want to copy a 7.13 Informix database over to a
7.20 instance. If I create the new database with
indexes, this will take forever to load. So, I
would like to create two schemas; one with all the
sql to create tables without indexes and another
with the sql for the indexes.
I used to accomplish this by grepping the output of
dbschema for 'create index' or 'create unique
index' and directing the output to a file. This
doesn't work now because a lot of my 'create index'
lines are now actually two lines and the grep will
just get the incomplete first line.
I hope this make sense to someone and doesn't
appear to be the incoherent ramblings of a rookie
(even though it is).
Thanks,
Dick Counsell