Hi,

> I have two intentions over here:
> 1) My window will have 2 tabs. Main tab is to display details which coming

from main table. Second tab is to display picture or memo. Only when user
clicks on second tab then only I select from the separate BLOB table using
the main ID. Most of the time user will not go into second tab.

>

You can do this easily by not including the BLOB columns in your first tab
query
and by executing a separate query from your table when the user goes to the
second
tab, no need for a separate table.

> 2) I would assume this design will have benefit of more compact data

storage on the data page. I am not 100% sure on this one :)

>

Only (very) small blobs will be put on the same datapages as the normal
table
data, the rest of the blobs goes into separate blob pages inside the
database.

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