Home -> Usenet -> comp.databases.oracle -> Accessing rows in large tables

Accessing rows in large tables

From: Tsagarakis Manolis <tzagara_at_cti.gr>
Date: 1996/05/22
Message-ID: <Pine.SOL.3.92.960522181420.10347A-100000_at_hermes.cti.gr>#1/1 








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 Wed May 22 1996 - 00:00:00 CEST












Original text of this message