RE: sql - Drop and Add constraints

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

If a clear was a "delete from table" followed by a reorg I'd agree, but my
understanding is that it's a special function where the database understands
that ALL the rows are going to be toasted so indicies aren't maintained
during the clear.

-Walden

------------
Walden H Leverich III
President
Tech Software
(516)627-3800 x11
WaldenL@TechSoftInc.com
http://www.TechSoftInc.com



-----Original Message-----
From: bill.reger@convergys.com [mailto:bill.reger@convergys.com]
Sent: Monday, January 07, 2002 15:12
To: midrange-l@midrange.com
Subject: RE: sql - Drop and Add constraints



Walden,

It's always been my impression that as the data is cleared the access paths
are maintained at that time.  Thus if you have a bunch of them the clear
takes longer.  I'm not aware of any "access path invalidation" although I'm
not as close to the system technically as I used to be.  Maybe this has been
improved over the last several releases, but it always seemed that the same
file with and without related access paths cleared in much different amounts
of time.

Bill

--

NOTICE:  The information contained in this electronic mail transmission is
intended by Convergys Corporation for the use of the named individual or
entity to which it is directed and may contain information that is
privileged or otherwise confidential.  If you have received this electronic
mail transmission in error, please delete it from your system without
copying or forwarding it, and notify the sender of the error by reply email
or by telephone (collect), so that the sender's address records can be
corrected.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.