DBIMPORT and indexes

Posted in 1995

Mark Denham — 26 Jul 1995 03:08:04 -0400 — source: Informix-list mailing list archive (1991-1998)

Steve wrote: >Question: >When doing a dbimport after a dbexport, and leaving the .sql as is, >will the dbimport load all the data for a table and then build the >indexes? Or will it build the indexes as it loads the data? (Which we >all know is a slow way to do it) >Steve Goldberg >Landata RE-Source >goldberg@landata.com I think you wil find that the data is loaded first, then the indexes are created. At least that is how it appears to be working in V5.03. I am watching one do its stuff right now! Boring eh? Mark Denham BBC London, UK Mark.Denham@bbc.co.uk