Need to kow these basic things from teradata guru's.
I have a table employee having 4lac record.emplno and deptno are columns apart from other columns. I have a table dept having 1000 records and deptno is UPI.
q1) how to choose PI for employee table. data distribution is primary consideration or fetching query output is primary criteria.
q2) which will be the good option i) emplno as UPI ii) emplno & deptno as UPI iii)deptno as NUPI q3) how does data distribution happens for the below two cases when employee table's deptno is joined with dept tables deptno. i) emplno as UPI ii) emplno & deptno as UPI
q4) when data distribution happens it happens in spool space or where?
Thanks a lot in advance.