There is a need to create table to store documents and images. We want to use CLOB data type. Question here is do we need to create single table vs multiple tables. In my case suggestion came to create 3 to 5 tables having clob's.
My questions:
Table with clob will have other 6 columns and stored inside database is to be considered.
1. when doing a search or DML's on them how this will impact the performance as this is OLTP system.
2. When running Reports.
Single table will have more benefits as against multi table is my thought.
What would be the best approach?