Hi DuyHai,
Thank you for providing your feedback to our question.
Just to elaborate on the 2 factors that you have provided above.
1) Collection cardinality e.g. the number of elements in the collection. A
maximum of 64,000 elements can be stored.
2) the size of each element in the collection. T
Hello Bill
First if you don't care about insertion order it's better to use Set rather
than list. List implementation requires read before write for some
operations.
Second, the read performance of the collection itself depends on 2 factors :
1) collection cardinality e.g. the number of elements
Hi Everyone,
We need some help in deciding whether to use User Defined Type(UDT) nested
in LIST collection columns in our table.
In a couple of months, we are planning to roll out a new solution that will
incorporate a Read heavy use case.
We have one big table which will hold around 250 million