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