Likec doing full table scan
                    
 Hello, 
                 
                We are using likec in 1 query and the table is very big. As we see the explain plan query is doing full table scan. 
But if I replace likec with like, query uses the index.
My question is , which type of index we can create so that query start using the index 
0