Re: performance question

Sounds like you have a DSS/OLAP type of database. Read up on materialized view and query rewrite. It may help you.

Vissuyk_at_yahoo.com (Vissu) wrote in message news:<16b21687.0206051302.7a662829_at_posting.google.com>...
> Hi All,
>
> We have multiple tables with over 15 million rows and growing fast.
> There is a about 50+ columns in these tables.
>
> Some queries use max(date) function to figure out the latest and
> greatest value belonging to a certain group. Lot of queries do order
> by and group by.
>
> Some queries are fast and some are slow. I want to recreate these
> tables and with the goal of making it fast and scalable.
>
> I am wondering if I should index organize these tables. I am not sure
> if I can use IOTs for such volume of data. Alternatively, I am
> thinking of partitions etc.
>
> Could anyone suggest better ways to achieve scalability and
> perfromance?
>
> RDBMS = Oracle 901
>
> Thanks much,
>
> Vissu
Received on Thu Jun 06 2002 - 17:21:07 CEST