I've always thought it would be great if there was a way to drop an object but keep the meta data so I can recreate objects without having to store the ddl somewhere.
alter table drop index retain metadata Would be helpful. Dave On Tue, Dec 04, 2001 at 11:19:43AM -0500, Robert Alexander wrote: > Hi Barry, > > It is, indeed, faster to load the data then create the indexes. > > Instead of 'disable' and 'enable', you could try: > - ALTER TABLE DROP index (or drop the table and create it without indexes.) > - load your data > - ALTER TABLE ADD index > > HTH, > > /Rob > > > At 09:40 -0500 2001/12/04, Barry Roomberg wrote: > >The actual load of a single table takes about 1/2 hour, but > >indexing takes DAYS. I've recompiled '--with-raid' which allows > >me to create a table big enough. > > <snip> > > >According to the docs, it seems that the following > >sequence should be faster: > > > >Create WITH indexes defined. > >Alter table disable indexes. > >Load data. > >Alter table enable indexes. > > > >The 'enable' and 'disable' seem to be strictly a MySQL 4.0 > >command, which I didn't initially DL, so I'm setting that > >up now. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Robert Alexander, Alpha Geek, Workmate.ca > WWW Database Applications and Web Hosting > http://www.workmate.ca 416-823-6599 > mailto:[EMAIL PROTECTED] > > "Life's unfair - but root password helps!" > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php