Jeff,

Thanks. I do not have DBA privilege and therefore cannot perform some of those tasks. This particular table has about 1 million rows and several indexes about 10 on heavily accessed fields and columns. The plan is RBO and the DBA's are moving to CBO soon. What else can I do from a developer/database analyst perspective to improve table performance?

Thank you.