Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IOT, INDEX_DESC and Rownum=1
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...Received on Mon Aug 16 2004 - 14:06:17 CDT
> 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
>
>