Hi all,

one of our tables is now contain 6 mil rows and growing in about 10k + rows each day, I know it's not consider huge table, but querying this table is still considerably slow compare to other tables. I know for sure that this table is pretty good indexed and i'm not sure what is my next step to improve query speed, I'm think of partition is this what i should go for ? is there any more steps i could take to improve this table performance ?

Thanks