Re: How to Find Space Allocated by an Index

ywu <ywu.pfizer.com> wrote:

->Can any one tell me how can I find how many bytes an index takes ?

->Thank you,

->Yong,

select * from user_indexes;

will list all kinds of info about the index.

Also,
select * from user_segments
where segment_type = 'INDEX'
group by segment_type, segment_name;

will list similar information.

You can also get similar information for all_indexes, all_segments, dba_indexes and dba_segments.

BTW, your chances of having your posting read will be much greater if you include a subject. Unfortunately I can not help you there. I use Netscape, but it's newsreader capabilities just don't make the grade. Ah, you've fixed the subject in this post, but still ... Also, you need to configure some things to get a valid reply address to appear in the posting.

--
Doug Henderson, Glen Coulee Consulting, Calgary, Alberta, Canada
[Sent using Free Agent 1.0]