Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: IOT, INDEX_DESC and Rownum=1
I've replied to this off-line.
-- 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 Sept 2nd "Wizkid" <hariharan.sam_at_wipro.com> wrote in message news:54626635.0408300420.11014fa8_at_posting.google.com...Received on Fri Sep 03 2004 - 02:27:32 CDT
> Jonathan,
> Thanx a lot for the response. Would await your response. Your reply
> made me want to consolidate all my postings on this thread(online and
> offline). Pl. find below the same:
>
> Background:
>
> . We are designing an application, at the heart of which is a large
> table expected to be of size 592 GB (493 GB Table and 100 GB index) at
> the end of 7 Years after granular purging.
>
> . Number of records is expected to be around 3.5
> billion
>
![]() |
![]() |