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