delete from table_name
actually DOES drop and recreate the table (and thus its indexes). On the other hand, if you are continually adding & deleting records, you might well need to do a periodic 'analyze table_name' or 'optimize table_name' to maintain optimum performance & clear the deleted record chain.
steve
At 03:21 PM 2/19/04, Jeff McKeon wrote:
Quick question...
What you drop a table are the indexes for that table dropped to?
I'm about to write a script to take a data pull every night and re-populate a table with the results, then have my apps run off of the new consolidated table for a speed increase. If I drop the Consolidated table, then re-create it with the new data pull, will I need to re-create the indexes as well?
Is there any performance cost/benefit to simply deleting all data from the table and then re-populating it as opposed to droping and re-creating it?
Thanks,
Jeff
+------------------------------------------------------------------------+ | Steve Edberg [EMAIL PROTECTED] | | Database/Programming/SysAdmin (530)754-9127 | | University of California, Davis http://pgfsun.ucdavis.edu/ | +---------------------- Gort, Klaatu barada nikto! ----------------------+
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
