Query on a blob table

[Raymond Kroeker]

Hi All,
   I have a table encompassing blobs as such:

CREATE TABLE DOCUMENT_VERSION
(
  DOCUMENT_ID BIGINT not null,
  CONTENT BLOB not null,
  CONTENT_SIZE BIGINT not null,
  CONTENT_CHECKSUM VARCHAR(256) not null,
  CHECKSUM_ALGORITHM VARCHAR(16) not null,
  CONSTRAINT DOCUMENT_VERSION_PK PRIMARY KEY (DOCUMENT_ID)
);


 Now I've loaded 175 rows of 256B blobs and a single row containing a 250MB
blob.  When I run the query

select sum(CONTENT_SIZE) from DOCUMENT_VERSION;

 it takes ~10s += 1.5s to complete.  Am I missing something?

 I've tried indexing CONTENT_SIZE (after seeding the data) without any
luck.

--
--------------------------------------------------------------------------------
Raymond Kroeker
thinkParity Solutions Inc.