Embodiments of the present invention include a database engine and optimizer framework that support creation of a series of profiling indices over {HEAD ~ a column} having {TAIL ~ character string data}, such as a traditional “varchar” or “char” data type 
Embodiments of the present invention include a database engine and optimizer framework that support creation of a series of profiling indices over { HEAD ~ a column } having { TAIL ~ character string data } , such as a traditional “ varchar ” or “ char ” data type
OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH HEAD HEAD HEAD HEAD HEAD HEAD REL TAIL TAIL TAIL TAIL TAIL TAIL TAIL OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH