Oracle Perfromance Tuning : I need some help with wildcard search with % operator at both ends. The no of records are nearly 7 million. 
Is there any option to setup an index for this. I already created an index of index type CTXSYS which works well for single % operator at one end.
Please help.