Re: How to optimize this query?

WiseGuy wrote:

> Have you considered creating a function index using SOUNDEX, and then
> performing a soundex query instead ?
>
> SELECT
> count(*)
> FROM t
> WHERE soundex(surname) = soundex('SMITH');

Er.. point being? What does this have to do with the OP's problem and subsequent discussion on index range scans?

Don't tell me. You're a tea drinker.. <sigh>

;-)

--
Billy