On Tue, Apr 4, 2017 at 2:04 PM, Douglas von Roeder via 4D_Tech <
[email protected]> wrote:
> 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).
>
I am using truncate. I just want to make sure that by using this command
then then running MSC repair, I will get new fast indices for these tables
and table space will be correct. If one uses delete command and deletes
most of the records table space is screwed up. That was my real question. I
was just not erudite enough to show it
Regards and thanks
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]
**********************************************************************
