size of an index

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 14 Aug 2003 17:39:04 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7041286D9@lnewton.leeds.lfs.co.uk>

Analyze index <index_name> validate structure; select <stuff> from index_stats;

Stuff can be BLOCKS (which is effectively what you want) or anything else like LF_ROWS (number of index entries) DEL_LF_ROWS (number of 'holes' waiting to be filled as new values get inserted), HEIGHT (how many levels in the index, each level = one block read when looking something up - then an extra for the data) etc.

HTH Regards,
Norm.

PS. INDEX_STATS only ever holds one row - the last index you analy[sz]ed.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----

From: Steven [mailto:SPAMBLOCKER_at_gmx.net] Posted At: Thursday, August 14, 2003 4:47 PM Posted To: server
Conversation: size of an index
Subject: size of an index

Hi,

Does anyone have a query whereby I can get the physical size of an index in
bytes.

Thanks,
Steve.

-- 


-----------------------------------------------------------------

Holidays in Berchtesgaden, Germany:
http://www.sonnenkoepfl.de
http://unterkunft-berchtesgaden.de
http://pension-berchtesgaden.de

Received on Thu Aug 14 2003 - 11:39:04 CDT