I am working on a project that requires a great number of CLOBS in different tables.

I have moved the CLOBS to non in-line storage for the data.

But, several tables have multiple CLOBS (five in places) as well as varchar2(2k to 4k).

Does anyone have any advice on how to design the tables for increased performance.

Thanks in Advance