Re: How to partition a table ? - suggestions

Past work we have done showed us that using LOCAL partitioned indexes worked the best. The administraintion of them is easier than using GLOBAL indexes.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"Orna Berlinsky" <ornab_at_amdocs.com> wrote in message news:4e2fb3ee.0107140457.387f7525_at_posting.google.com...
> 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 - 04:05:01 CDT