Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Truncate and Indexes
>Subject: Truncate and Indexes
>From: Jeff Hunter <jhunter_at_isrv.com>
>Date: 1/27/98 11:16PM GMT
>Message-id: <34CE6ACE.A33551E_at_isrv.com>
>The answer seems obvious but I want to run it past the
>experts first. Suppose you have table A and table A has
>an index called X. When you truncate table A does index
>X reclaim its space.
>
>Thanks in Advance
>--Jeff
>
>Jeffrey Hunter Internet: jhunter_at_isrv.com
>Programmer/Analyst WWW: www.isrv.com/~jhunter
>PO BOX 832 Voice: (412) 284-7325
>Butler, PA 16003-0832 FAX: (412) 789-9601
>
>
Indeed it does
Rob Received on Wed Jan 28 1998 - 00:00:00 CST