Re: Phone Numbers

Richard wrote:

> Do you need to search on the whole phone number, e.g. to identify an
> individual subscriber or do you just need to identify the 'location' of the
> phone number, e.g. to identify which exchange or charge group it is
> associated with?

I need to search the whole number just to see if it exists (do-not-call-list). I would prefer to keep area code in a separate column though - unless you think this is a bad idea. I also do not have Oracle EE, just SE - so I don't have access to bitmapped indexes. Also there are no updates and very rare deletes. So mostly (98%) reads.

>
> Regards,
>
> Richard
>
> "v5034" <v5034_at_vm.vm.co> wrote in message
> news:vs80klekuf1pb3_at_news.supernews.com...
>

>>What is the best way to store, index and search N. American phone
>>numbers for maximum search efficiency? Should they be broken up and
>>stored as area code columns and number columns? How should they be
>>indexed? I have a standard Oracle database - not EE.
>>How should they be searched for efficiency?
>>
>>Thanks
>>