Re: Disk size of an Index

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

Hi Vinay,

You don't say how many rows there are in the table.
Index 2 is probably taking advantage of Index 1 so I don't see anything out
of line with the sizes.


Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (905) 486-1162 x 239
Cell: (416) 317-3144


On 5 February 2018 at 15:35, Vinay Gavankar <vinaygav@xxxxxxxxx> wrote:

> My client has a large partitioned file defined as an SQL Table, which has 3
> different Indexes defined.
>
> Size of one of the index size is about 3 times that of the others. We were
> trying to figure out why, and whether anything can be done about it.
>
> Record length : 381 bytes (no variable length or date format fields)
> Index 1 : Key length 60 bytes (Fields A - 18, B - 9, C - 15, D - 15, E -
> packed 5,0) - Unique
> Index 2 : Key length 61 bytes (Fields A - 18, B - 9, C - 15, D - 15, X -
> packed 7,0)
> Index 3 : Key length 64 bytes (Fields Y - packed 7,0, A - 18, B - 9, C -
> 15, D - 15, E - packed 5,0)
>
> No selection on either index, so number of index entries on all is the
> same.
>
> Index 1 is about 223 GB, Index 2 is about 151 GB, Index 3 is about 680 GB
>
> Any ideas?
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD