Re: Q: How much space is required for indexes?
> I'm relatively new to Informix and am trying to some space planning > for our DB. One thing I've been unable to determine is how much > space is used by indexes. The DB Admin Guide refers to the SQL > Tutorial, but I can not find any useful information in either > document. > > We're using On-line 5.02. > > BTW, where's the FAQ? I've surfed through the usual locations but > can't find a FAQ archive that includes anything on Informix. > > TIA > > Mike > -- > krajnakm@med.ge.com / V: 414.521.6342 / GE Medical Systems There is a pretty thorough discussion of how to calculate approximate index sizes in the "Informix Guide to SQL Tutorial" v4.10 July 1991 (part number 000-7117) starting on page 10-12. CAUTION!! There is a typo on page 10-17! The value for pageuse should be 2020, NOT 2016. Also the formula for entsize should be "4 * 1.0 + 4" The FAQ can be found at the home of the International Informix User's Group (are YOU a member yet?) http://www.iiug.org/techinfo/faq/faq_top.html Or via anonymous FTP (the old-fashioned way) at: Name: kcbbs.gen.nz IP: 202.14.102.1 Location: New Zealand, GMT + 12 Access: Anonymous FTP Directory: /informix Contact: Kerry Sainsbury <kerry@kcbbs.gen.nz> Contents: Files related to the Informix FAQ listing (primary site). Enjoy. __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|