index

Database

index

1. What does the complete 32 bit hash number denote?

2.What is meant by : Table is sorted according to row id in the AMP?

3.While retreiving a row from AMP how do we get the physical address if two rows reslult in same row hash vale?If it is accessed through uniqueness number assigned then how do we get it during retrieval?

4.What happens when we are not taking all the PI columns while retreiving data in Where cluse?How is it hashed?

5.Why we cannot have UPI on table that is partitioned by column not included in PI?

6.How assigning a USI helps to handle partition on columns that is not part of PI?