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 character string data, such as a traditional “varchar” or {TAIL ~ “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 character string data , such as a traditional “ varchar ” or { TAIL ~ “ 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 OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH OTH TAIL TAIL TAIL TAIL TAIL TAIL TAIL TAIL TAIL