tdatgod,
Thanks for the reply - the point of this JI is to redistribute the data on a different hash key. We have a ton of consumers that belong to consumer groupings. the xref table is hashed on consumer id (CID) but the JI is hashed on the CID group.
So if I go after a CIDgroup with 5...
Does anyone know a trick I could use to get the TD PE to not use an existing join index? Dropping the index is not an option for me.
In one case, I have been able to write a view over a table and include a column that's not in the JI - that worked fine. Solutions like that would be very...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.