Question
John Hotalen · Aug 31, 2016

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

00
1 0 2 454
Log in or sign up to continue

Thank you Eduard for the information and the quick response.