Re: My first large table

johnleslie_at_madasafish.com (John Leslie) wrote in message news:<4412dd31.0307180425.760beccc_at_posting.google.com>...
> Currently have a small database with no table having more than 50000
> rows.
> Now we have a requirement to load large amounts of data into a table
> which will be held for 3 months, resulting in several million rows.
> The data will be loaded using sqlldr and thereafter queried for adhoc
> report purposes only.
>
> Just want to know, what are the basic things I need to do in setting
> up this table to ensure decent performance.
>
> Do I need to reorganize the table indexes on regular basis to retain
> performance? If so how? As you can tell I'm quite new at this!
>
> Thanks in advance,
> JL

JL, the correct answers depend on your data, which columns are indexed, and how the data is accessed, but in general it is unlikely you will need to reorganize the indexes very often. Updates that change the value of indexed columns and delete activity are the two primary drivers that may make index re-organization necessary usually to reclaim space more than improve performance.

You may want to consider building this table in its own tablespace to separate it from your existing small tables.

HTH -- Mark D Powell -- Received on Fri Jul 18 2003 - 15:29:24 CDT