Need help with LONG RAW format

From: TSP Fossa <sonnypf_at_ymmi.co.id>
Date: Fri, 3 Jul 1998 08:28:26 +0700
Message-ID: <6nhcg2$n7c@news1.rad.net.id>

Hi ...

I've create a table employee with these settings :

Name                            Null?    Type
------------------------------- -------- ----
ID                              NOT NULL VARCHAR2(7)
NAME                                     VARCHAR2(40)
JOB_ID                                   VARCHAR2(7)
ORG_ID                                   VARCHAR2(4)
MARITAL_STATUS                           VARCHAR2(2)
TAX_STATUS                               VARCHAR2(2)
DRIVER_LICENSE                           VARCHAR2(20)
CITIZEN_ID_CARD                          VARCHAR2(30)
PHONE                                    VARCHAR2(25)
IN_DATE                                  DATE
PHOTO                                    LONG RAW
EMP_STATUS_TYPE                          VARCHAR2(1)
FLAG_STATUS                              VARCHAR2(1)

and I made forms to insert bmp photo to column PHOTO. But as the number of employee grows ( and so do the number of photos, each about 50 kb ), querying records from the employee table needs more time ( querying a record can be up to 1 minute ).
Can anybody help me how to speed up the query. I've tried setting photo to NULL in the employee table, and put the photo in another table but it didn't give any significant difference. Received on Thu Jul 02 1998 - 20:28:26 CDT