Re: number of records

Kirstin Mikalauskas Simacek wrote:
>
> Has anyone ever had an Oracle database with 30 - 50 million records in
> one table? What was the impact of such a large table on processing?
> How about on a simple SELECT?

  For a large table, tuning is quite important. There are numerous tuning point for obtaining a good performance even on a single SELECT such as the value of DB_FILE_MULTIBLOCK_COUNT if you are using PQO or the setting of index. Please refer to some tuning references if you want to get a good performance.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841