Re: [Q]: Indexes with LIKE clause

In article <39mjll$fni_at_s.ms.uky.edu> neil_at_ms.uky.edu "Neil Greene" writes:

> What ill effects does the use of a LIKE clause have with respect to
> index performance, if any??
>
> -- Neil
>

        Depends on how the users specifies the range.

        Assume an index on ename then the following could use the index

	'K%'
	'KI%'

	These won't use the index

	'%K'
	'%KI%'

	So educate the users to use the first form if possible.

-- 
tim london