× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Table has a total of 5.9 billion rows. I am worried about size of Index 3
compared to Index 1

On Mon, Feb 5, 2018 at 3:37 PM, Glenn Gundermann <glenn.gundermann@xxxxxxxxx
wrote:

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

--
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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.