Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by terminalclick

  1. terminalclick

    AMP Usage Via SQL

    That's great, seems to be what I wanted! Thanks!
  2. terminalclick

    AMP Usage Via SQL

    Please could someone point me in the direction of some DBC sql which I can run while a query is running to see what AMPs it is using? (I am having an issue with SPOOL space running out, and I think it's because I have skewed data, where the query is only using one or two of the full amount of...
  3. terminalclick

    Data Distribution Using Primary Index

    Hi, I think I'm correct in saying that the Primary Index is set against a table to effect data distribution across AMPs. So, in effect, a good primary index is a column containing unique data. Am I therefore correct in thinking that if a 'serial' column is added to a table to just count from 1...
  4. terminalclick

    Skew Factor vs Primary Indexes vs AMPs used

    First time post, so please bare with me. :-) Please could someone explain the relationship between Skew Factor on Primary Indexes and which AMPs will be used? Am I right in thinking the skew factor on a primary index is where there are large variances in the amount of different primary index...
See more

Part and Inventory Search

Back
Top