Random question of the day! How are LOBS stored in the DB? We have a table which is used to store PDFs and Word Docs as BLOBS in the DB. I've done a tabanalys and it reckons the table is taking up 20.9M for ~210k records. Which is surprising as the files stored average around 2MB. Or am I missing something in my interpretation of tabanalys?
Code:
-Record Size (B)- ---Fragments--- Scatter
Table Records Size Min Max Mean Count Factor Factor
PUB.BinaryObject 210595 20.9M 48 282 104 210595 1.0 1.0