> Is the index and table useage suitable for any sort of partition scheme that
> would allow the data to be broken up into multiple tables with the same
> structure i.e. data "buckets"?
>
> This would involve quite a bit more admin when adding and retrieving data,
> but may delay the onset of the symptoms you are suffering.
This would definitely help. Oracle Enterprise supports partitioning, but
upgrading from standard for this one standalone table is not really feasible.
We could consider a do-it-yourself partitioning. Select performance is excellent
though and a move to complex scheme will impact that. I agree though it might
be the way to go.
----------------------------------------------------------
Phil Scadden, Institute of Geological and Nuclear Sciences
41 Bell Rd South, PO Box 30368, Lower Hutt, New Zealand
Ph +64 4 5704821, fax +64 4 5704603
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
