Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to partition a table ? - suggestions

Re: How to partition a table ? - suggestions

From: Palmer <palmer_at_netdoor.com>
Date: Sat, 14 Jul 2001 22:40:52 GMT
Message-ID: <3B50CBDF.276B8E0F@netdoor.com>

Orna, I would start by building compressed indexes (if you have support for that in your version of Oracle) or Index-organized tables.. You might also consider hashing the key.
I would find some way to log the searches for a while and see which ranges of names get more frequent searches, then use that information to determine the best ranges for partitioning. HTH Orna Berlinsky wrote:

> 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 - 17:40:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US