Yes , we will be implementing a horizontal partition on the main tables , with a partition for each month.

regarding the indexes , we will be loading data once every 5 - 10 minutes, so i was wondering if i should use the indexes since the tables will have frequent inserts happening . I also need to implement full text indexing as well.

I need the ETL to complete in 5 -10 minutes before it starts all over again.

Indexes i think could become a performance bottle neck during etl , am i right ?

Thanks again for your help.