[IQUG] [iqug] Simple question

Louie, David David.Louie at blackrock.com
Tue Mar 20 12:05:31 MST 2018


Here's a simple one.

Is it worth putting an HG join index on a 1 mb table with 6 rows which is being used to join to a 172 million row 68 gb table?

Not just joining on the HG col but I have a where "col from this small table" = 'value'

I'm going to guess it wouldn't hurt.

Thanks
David


This message may contain information that is confidential or privileged. If you are not the intended recipient, please advise the sender immediately and delete this message. See http://www.blackrock.com/corporate/en-us/compliance/email-disclaimers for further information.  Please refer to http://www.blackrock.com/corporate/en-us/compliance/privacy-policy for more information about BlackRock's Privacy Policy.
For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/en-us/about-us/contacts-locations.

(c) 2018 BlackRock, Inc. All rights reserved.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 9645 bytes
Desc: not available
URL: <http://iqug.org/pipermail/iqug/attachments/20180320/da980c5d/attachment.bin>


More information about the IQUG mailing list