Re: how to improve "select num from telebook where num like '%345%'"

qiangye_at_my-deja.com napisa³(a) w wiadomo¶ci: <8p50l5$sdg$1_at_nnrp1.deja.com>...
>We have a huge table storing all of the telephone numbers of the city.
>The query is to retrieve all the numbers which contain "345" in the
>middle position. The current performance is too slow. Anybody knows how
>to improve the performance like that query?

Maybe this help:

create index num_ind on telebook(num);
select /*+index_ffs(telebook num_ind)*/ num from telebook where num like '%345%';

Regards,Roblop Received on Wed Sep 06 2000 - 12:43:48 CDT