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

Home -> Community -> Usenet -> c.d.o.misc -> Re: BLOB/CLOB or Organization Index advice

Re: BLOB/CLOB or Organization Index advice

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 14 Nov 2004 13:32:42 -0800
Message-ID: <1100467883.283929@yasure>


Alf wrote:

> Hi,
>
> Currently I have a table set up as Organization Index. Three variables
> define the index to the parent and four numeric variables are the row data
> (1 to 4 completed).
>
> On average I have 25 rows but at an extreme I could have well over 100.
>
> My database is PC based and with just over a months worth of data I have
> 2635053 rows of detail data for 98950 parent rows - and I intend to have
> many months on-line - though they will be accessed through other tables so
> it can be split between many tablespaces segregated by time (although I
> haven't really though about that yet).
>
> Also, for my application, it generally only makes sense to access the detail
> rows via the parent and access is mainly for reports so fast real-time
> access is not really a priority.
>
> So, finally, my question: is organization index the "best" way to go about
> storing this data given the above?
>
> Are there overheads or limitations implied that I may hit as the amout of
> data grows?
>
> Or, would I be best served packing the data into a BLOB/CLOB field in the
> parent table and parsing out the data into its individual rows as needed on
> query?
>
> Thanks for any input/advice.

I'd be thinking range partitioning using Enterprise Edition.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sun Nov 14 2004 - 15:32:42 CST

Original text of this message

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