1. Single table join index:- As per my understanding, single table join index gives us flexibility to change PI of the table and we use only one table i.e no join with other table is required.
My question is in Single table join index, does joing between the tables takes place or not as i have read in forum that only one table is used?? Description with example will be helpfull for me.
2. In USI and NUSI, can both table (base and sub table) reside in same amp. If yes, how??
3. Since we don't have dense rank function available in Teradata, what is its alternative??
I have referred earlier posts but i'm not able to understand above questions clearly.
Many thanks in advance,