[IQUG] How bad in IQ are mismatched datatypes in join cols
d.rittenhouse at sap.com
Thu Nov 2 15:44:15 MST 2017
You should beat them aggressively. ;-)
IQ will convert the smaller datatype to the larger datatype for every entry in the column.
For small tables you may not notice the impact, but if you have billions of entries it could be a significant performance impact (potentially orders of magnitude.)
Hope you get them to see the light..
Senior Consultant, SAP Data & Technology Services
Service & Support
SAP (UK) Limited
Clockhouse Place, Bedfont Road, Feltham, TW14 8HD Middlesex, UK
E: d.rittenhouse at sap.com<mailto:d.rittenhouse at sap.com>
M: +44 (0) 7899 948 295
Please consider the environment before printing this email.
From: iqug-bounces at iqug.org [mailto:iqug-bounces at iqug.org] On Behalf Of Louie, David
Sent: 02 November 2017 21:52
To: IQ Users Group <iqug at iqug.org>
Subject: [IQUG] How bad in IQ are mismatched datatypes in join cols
I know that in ASE it’s a big problem. Is it the same magnitude in IQ? I would think so but want to know how aggressively I should be beating our developers :D
The index advisor is finding a lot of datatype mismatches on join cols in our queries.
For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/en-us/about-us/contacts-locations.
© 2017 BlackRock, Inc. All rights reserved.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the IQUG