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: IOT, INDEX_DESC and Rownum=1

Re: IOT, INDEX_DESC and Rownum=1

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 16 Aug 2004 19:06:17 +0000 (UTC)
Message-ID: <cfr0j9$7ff$1@titan.btinternet.com>

IOTs will scale to the sort of volume you want.

You may need some care to ensure that you have identified all the critical classes of query otherwise you may find that your structure imposes an unacceptable overhead
on some queries.

Based on your current comments, I would
seriously consider range-partitioning by DAY rather than month, and not prefixing the index - it looked from your main example as if the date-stamp would be more effective as the last column in the index rather than the first.

Of the 7 year data set, how much will you have as you go live ? 7 * 365 partitions is a little close to the sensible limit at present, but 9.2.0.5 and 10.1 have a couple of features that make partition handling much less stressful.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated July 27th




"Wizkid" <hariharan.sam_at_wipro.com> wrote in message
news:54626635.0408152206.f8c9ffa_at_posting.google.com...

> All,
>
> Wanted to add few more facts regarding the question I had stated on
> Saturday:
>
> a) The range partitions planned would be monthly partitions
>
> b) Partitions would contain dataitems with different retention periods
>
> c) The system is an OLTP system.
>
> d) Plenty of cyclic and time-specific batch programs pump data at a
> frenetic speed along with the real time data input via AQ into the
> table in questions. A very high throughput requirement is there for
> consuming messages from the real time system.
>
> e) Usage of sub-partitioning (range-list) is being considered to group
> related dataitems together within a monthly partition.
>
> I have an additional question as well:
>
> a) Would IOT scale up to such monstrous requirements?
>
>
> Rgds
> Hari
>
>
Received on Mon Aug 16 2004 - 14:06:17 CDT

Original text of this message

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