[FOLLOW UP QUESTIONS TO #9916]
In your explanation, when you added email for 'Alice' partition key , for the same partition key there will be 2 rows in table right? Like now after is addition you have total number of keys estimate as 2.
Then eventually is 'number of partitions (estimate)' = number of total rows (estimate)in a table?
I had a test table in which i hade 20k records and number of keys (estimate) was 3 . I believe this 3 is from the partition key
I think i am missing something .please update me
could you explain the diff b/w total partitions and total number of rows in a table based on the example context?