If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Just to add this, we are testing the performance of the select statement through a Java application. And below are the details of the Table (with storage parameters).

Please note that the BLOB is moved to a seperate tablespace for better performance. The Block Size for BLOB is increased from 8K to 16K and also the Chunk size of Tablespace for images is set to 32K and CACHE is set. We had done these changes to improve BLOB insertion, and the results of BLOB insertion after doing these changes is amazing as it is taking less than 10 milli seconds for inserting images.