Re: How to Find Space Allocated by an Index
From: Jay Ramadorai <76734.3633_at_CompuServe.COM>
Date: 1995/08/15
Message-ID: <40qcja$k94$2_at_mhafm.production.compuserve.com>#1/1
Date: 1995/08/15
Message-ID: <40qcja$k94$2_at_mhafm.production.compuserve.com>#1/1
try
select bytes, extents
from sys.dba_segments
where segment_name = 'indexname'
and owner = 'indexowner'
Hope this helps
-- Jay Ramadorai Software Builders (404) 395-6465 ext108 cserve: 76734, 3633Received on Tue Aug 15 1995 - 00:00:00 CEST