If you can use it "WHERE name LIKE 'v_name%'", index created on 'name' column will be used if 'v_name' is (not sure about it!) 3-4 characters long (i.e. if you use first few letters of the 'name'). If I'm not wrong, use of '%v_name%' will not use index.