Re: CREATE INDEX is sooo slow! any ideas?

DAT ON FACTDET20028 (DAT) ; CREATE INDEX ANOCTYDAT ON FACTDET20028 (ANO, CTY, DAT) ; I've tried to create the indexes two ways : 1.before loading the date into table ("LOAD DATA local INFILE ... ") 2. after that. Both ways it's the same thing. --

HEPL: LOAD DATA LOCAL skips recors

nd i do "LOAD DATA LOCAL INFILE '.TXT' into table fields terminated by ' ' " it works just fine, but i need the first way. Please help me. Thank you. -- Sebastian Stan [EMAIL PROTECTED] ---