Re: Disk size of an Index

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