Chuck: I'd go with truncate.
It's a command whose function is to clear all the tablespace allocated to records in a given table along with the associated indexes. Delete selection is used to delete one or more records, ensuring that indexes and relational integrity constraints are enforced for each record deleted. I've used truncate a couple of times and it's *very* fast. In a V13 system, Truncate table deleted 10 GB of tablespace//11MM records in 10 seconds (MacBook Pro with SSD). -- Douglas von Roeder 949-336-2902 On Tue, Apr 4, 2017 at 10:43 AM, Charles Miller via 4D_Tech < [email protected]> wrote: > I seem to remember a tech note or example that would fix index problems > that you would have when deleting most of the record in a able or or > truncating it. I can not seem to find it. I wanted to make sure that if we > run a repair after doing this that all will be as it should. The two tables > we are truncating grow quite large. One for example now has more than > 30,000,000 records > > We are running v15. > > Can anyone point me in the right direction > > Thanks and regards > Chuck > > -- > ------------------------------------------------------------ > ----------------------------- > Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 > Informed Solutions, Inc. > Brookline, MA 02446 USA Registered 4D Developer > Providers of 4D, Sybase & SQL Sever connectivity > http://www.informed-solutions.com > ------------------------------------------------------------ > ----------------------------- > This message and any attached documents contain information which may be > confidential, subject to privilege or exempt from disclosure under > applicable law. These materials are intended only for the use of the > intended recipient. If you are not the intended recipient of this > transmission, you are hereby notified that any distribution, disclosure, > printing, copying, storage, modification or the taking of any action in > reliance upon this transmission is strictly prohibited. Delivery of this > message to any person other than the intended recipient shall not > compromise or waive such confidentiality, privilege or exemption > from disclosure as to this communication. > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
