How to partition a table ? - suggestions

Hi,

I have a huge table with telephone numbers AND listed names information.
This table will be searched extensively for specific telephones ( exact matches usually ) and for names ( usually not exact matches , but something that would necessitate using LIKE '<partial name>%' etc.. ).
SO name searche has a potential to be heavy and result with many records - much more then TN search..

I want to partition the table, and I do not know what is the best way to do it and which indexes should I create ( LOCAL , GLOBAL )

This table is used also for batch processes , not only online searches. but batches are more fot TN then names.

by huge I mean - tens of millions of records.

Any suggestions ?
Orna Received on Sat Jul 14 2001 - 07:57:28 CDT