First consider how to partition the table. If you can partition on a key that separates your active transactional data from the history, do so. The question of whether to partition indexes hinges on what columns are usually mentioned in query predicates. I'd recommend reading up on partitioning strategies; look in the Oracle docs and on MetaLink for some guidelines.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.