Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Truncate and Indexes

Re: Truncate and Indexes

From: L120bj <l120bj_at_aol.com>
Date: 1998/01/28
Message-ID: <19980128103701.FAA22625@ladder03.news.aol.com>#1/1

>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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US