Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORACLE 7.3 - Querying Very Large Table

Re: ORACLE 7.3 - Querying Very Large Table

From: TurkBear <johng_at_mm.com>
Date: Mon, 08 Nov 1999 16:33:08 GMT
Message-ID: <3826fafc.7033253@super.news-ituk.to>


If the user is truly just browsing ( not using a query ) then there is little you can do to add efficiency except to check indexes and keys - What is the user using to browse ?

captain_bananas9955_at_my-deja.com wrote:

>What is the most efficient way in ORACLE 7.3 to allow the user to
>browse through a table with 1,000,000+ rows ?
>
>Apparently ROWNUM is not available in 7.3
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Nov 08 1999 - 10:33:08 CST

Original text of this message

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