Re: Oncheck -pc: Index record size = 2048
Posted in 1998
Jay Aymond — — source: Informix-list mailing list archive (1991-1998)
Joe Blackman <joe@jblackman.demon.co.uk> wrote:
>Does anybody know if this is a bug?
>
>The output of 'oncheck -pc' always sets the 'Index record size' to 2048:
>
> Index information.
> Number of indexes 1
> Data record size 20
> Index record size 2048
> Number of records 0
>
>It seems a bit pointless to point out that an 8-byte index (in this
>case) will always occupy at least one page.
>
>
There are multiple index records stored per page. The smaller the index, the
more you get per page.
___________________________________________________________
Jay Aymond
EXE Technologies
jay_aymond@exe.com