home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.databases.informix
- Path: sparky!uunet!haven.umd.edu!wam.umd.edu!dinguyen
- From: dinguyen@wam.umd.edu (Dzi Nguyen)
- Subject: Index Size
- Message-ID: <1992Jul30.222846.14964@wam.umd.edu>
- Originator: dinguyen@rac1.wam.umd.edu
- Sender: usenet@wam.umd.edu (USENET News system)
- Nntp-Posting-Host: wam.umd.edu
- Organization: University of Maryland at College Park
- Date: Thu, 30 Jul 1992 22:28:46 GMT
- Lines: 36
-
- Hi netter,
- Does anyone know exactly how to calculate the total index size of a
- particular table like you see when you do dbschema. According to the
- Informix Training 'Book', add 8 bytes to the length of each key, and then
- sum up all index entries, this should be the total index size. But this
- never work unfortunately.
- ex:
- { TABLE "dnguyen".foo_tbl row size = 34 number of columns = 8 index size = 70 }
- create table "dnguyen".foo_tbl
- (
- f1 serial not null,
- f2 char(8) not null,
- f3 char(1),
- f4 char(6),
- f5 char(1),
- f6 char(1),
- f7 char(1),
- f8 char(12)
- )
- create index "dnguyen".i_f1 on "dnguyen".foo_tbl (f8);
- create index "dnguyen".i_f23 on "dnguyen".foo_tbl (f2,f3);
- create index "dnguyen".i_f1 on "dnguyen".foo_tbl (f1);
- create index "dnguyen".i_f4 on "dnguyen".foo_tbl (f4);
-
- thanx in advance...
-
- ------------------------------------------------------------------------------
- CSC - Partner
- Dzi Nguyen
- dinguyen@wam.umd.edu
- ------------------------------------------------------------------------------
- --
-
-
-
- **********************************************************
-