Hi,

> I have few tables which have data from hundred thousand of records to

millions of records.

> All these tables either have BLOB subtype 0 or 1.
>
> My question is there any benefit to move these BLOB columns out of the

main tables?

None, there could be some benefit, but only if you do SELECT * always, which
you shouldn't
be doing anyway.

> For example, I will create 2 respective BLOB tables (one table for BLOB

subtype 0 and another table for BLOB subtype 1).

> And this BLOB table will only have 2 columns (ID and BLOB) and the ID will

point back to main tables.

>
> Any comment of the above design?

What's your intention?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com