I'm facing a specific sort problem.There are several thousands of articles sold all over. Users expect to get a description in local language sorted by their specific collation.I have simplified

I have a persistent class that represents cities across the United States.  It is below, but basically has a City Id, Name, Lat, Lon and a few other unimportant fields for this issue.  Anyti

This is the first in a pair of articles on SQL indices.Part 1 - Know your indices What is an index, anyway? Picture the last time you went to a library. Typically they have books sorted by s

See Part 1 here.Part 2: Index Handling Now you have a good idea of what kind of indices you need for your class and how to define them. Next, how do you handle them?  Query Plan (REMEMB

Have some free text fields in your application that you wish you could search efficiently?  Tried using some methods before but found out that they just cannot match the performance needs of your

Hi,I know of the existance of (ELEMENTS) to create an index from a list, but I actually would like to index the content of an element of a list. Is it possible? My scenario:Class:Property Test As

Just wondering an Insight in the difference between these two indexesIdKey / PrimaryKey================= Property Identifier As %IntegerIndex Index1 on Identifier [Idkey]Index Index2 on Identifie