Sorry guys , Please find the detailsbelow
1. Character set & Collation ” utf-8 , utf8-genral_ci ( we need case insensitive column for string search)
2. bh.err file attached , Search string “%” you will queries like “google%’ , ‘micro%’, “big%’ these are taking time.
Mean time i have tried split this column with 64 varchar and tried same start with search , seems faster read some post in infobright that knowledge grid /char mao will handle 64 varchar column efficiently. Yet to confirm this performance in production with multiple user access.
Waiting for your suggestion.