the table?
Thanks for the help!
Jeff
-Original Message-
From: Chris Nolan [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 9:35 PM
To: Steve Edberg
Cc: Jeff McKeon; [EMAIL PROTECTED]
Subject: Re: Does Dropping a table affect it's indexes?
Steve Edberg wrote:
It's my
It's my understanding that doing a simple delete
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
Steve Edberg wrote:
It's my understanding that doing a simple delete
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'