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

  • 0
  • 0
  • 346
  • 1
  • 1

Answers