Understanding Wide and Skinny Row...

A Row in a Table can be called as Wide or Skinny depending on the no of Columns in a Table. A Row can be called Wide row if the table contain Columns in Thousands or Millions #59

Compound Key & Wide Row


Primary Key associated with Wide Row can can be called as Compound Key as it involves 2 Keys #60
  1. Partition Key
    1. Helps to identify the Node in which a Wide Row/ Partition has been stored #60
    2. Composite Partition Key : When a partition key is specified by more than one Column it is called Composite Partition Key
  2. Clustering Key
    1. Controls how data is Sorted within a Partition 
    2. Is Optional

No comments:

Post a Comment