Re: Accessing rows in large tables

Question #1- To be efficient in accessing large tables you must use an index or Oracle wil do full table scans. Ignore your 'red somewhere' unless you can find it again and verify the source and circumstances.

Question #2- Our site has several tables over 1 million rows but I would first recommend an hour or 2 with the manuals Oracle provides. Another source is "Oracle Performance tuning" by O'Reilly & Assoc.

HTH Tsagarakis Manolis (tzagara_at_cti.gr) wrote:
:
: Hi there,
:
:
: I am currently working on a project, where we will have large tables. There
: will be a table, with maximal 1 million rows. We don't know the exact
: number of rows it will have. Assuming the worst case (1 million rows) we
: are looking for ways, to access rows fast. I've never worked with large
: tables in ORACLE, so I have the following questions:
:
: 1. Is it efficient to use indexes ?
: I red somewhere, that building indexes is efficient
: only for tables having number of rows in a particular range
: (eg. from 3000 to 300,000 rows).
:
: 2. Can someone point me sites, where I can find about large tables in
: ORACLE ?
:
:
: Thank you very much in advance
:
:
: PS. We have ORACLE 7.2 on a DEC Alpha 5/300
:
: ************************************************************************
: Emmanuel Tzagarakis, tzagara_at_cti.gr
: Computer Technology Institute (CTI)
: University of Patras
: Patras
: Greece
: *************************************************************************
:
:
:
:
:
:
:
Received on Thu May 23 1996 - 00:00:00 CEST