Indexing - How to create an index on a List property
Hello Fellow Cache Developers:
Has anyone ever created an index on values of a list property? If so, would you be willing to share an example?
Also, feel free to offer input and suggestions regarding use of indexes on List values.
Here is my database scenario:
Parent Class:
PropertyA - %String
PropertyB - %Integer
Child Class:
PropertyC - %Integer
PropertyD - list of %Integer
Data illustration:
PropertyA + PropertyB maps to one or more occurrences of [PropertyC + list of values for PropertyD]
ABC + 90001000 maps to 6600012113 + list (86001000, 86982277, 86982271)
ABC + 90001000 maps to 6600087886 + list (84002300, 82911287)
ABC + 90001000 maps to 6410203911 + list (53010002, 53028878, 10099210, 90098876, 19029993)
ABC + 90001000 maps to 6922300119 + list (90998900)
The SQL queries could do lookups based on PropertyA+PropertyB, or based on PropertyC, or based on a value from PropertyD (the list)
Thanks in advance for your time and input!
Best Regards,
John