Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Posts
    94

    Unanswered: Non Collocated joins

    Hello,

    I am struggling with a non-collocated join between 2 massive tables. Is there a way of alleviating the distribution key disparity between non-collocated tables? (Do indexes help? not from what I am seeing!)

    Thanks as always
    G

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I don't think you need to struggle with non-collocated joins. If you cannot use the same (or at least compatible) distribution keys in the tables being joined, you'll just need to accept the reality.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •