> Hi Ari,
>
> I am an Oracle Developer (Forms 4.5).
> I have following Query.
> In Oracle Manual it has been suggested to
>
> "Place each LONG column in a table separate from other
> associated data. This prevents SQL statements from scanning LONG
> columns during full table scans" .
>
> My problem is How to do this during table creation.
> I know that LONG column should be last in table definition.
> Please guide me in this matter.
> Thanks and regards
> Prashant
Prashat,
What Oracle recommended was to create an entirely NEW table. So, instead of
making a table like the following:
TABLE_A:
-------
ID varchar2(100)
NAME varchar2(100)
SALARY number
DESCRIPTION LONG
you should make TWO tables, joined by the primary key (in this case ID):
TABLE_A:
-------
ID varchar2(100)
NAME varchar2(100)
SALARY number
TABLE_B:
-------
ID varchar2(100)
DESCRIPTION LONG
This will improve scanning the table for names and salaries. To get the long
column, you can always join table_a and table_b.
Best of luck!
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 160+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page