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: Fri, 3 Sep 2004 07:27:32 +0000 (UTC)
Message-ID: <ch96d3$fi0$1@titan.btinternet.com>

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...

> 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
>
Received on Fri Sep 03 2004 - 02:27:32 CDT

Original text of this message

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