Well the leading wildcard in that LIKE clause will guarantee it will have to do full scans.  Something LIKE 'text%' is fine though.  I guess it comes down to your requirements.