clob column position impact
Hi,I have the impression that CLOB/BLOB columns should always be in the last positions when creating a table. Like this.
CREATE TABLE test (
a VARCHAR2(10),
b NUMBER(10),
c CLOB);
What if I place the CLOB in the middle, like this?
CREATE TABLE test (
a VARCHAR2(10),
c CLOB,
b NUMBER(10));
Any Oracle documentation mentions negative impact on performance due to the CLOB column position?
Assuming my table has more than 100 columns and several CLOB columns. The above example is just a simplified version.
Thanks in advance,
Sha
CREATE TABLE test (
a VARCHAR2(10),
b NUMBER(10),
c CLOB);
What if I place the CLOB in the middle, like this?
CREATE TABLE test (
a VARCHAR2(10),
c CLOB,
b NUMBER(10));
Any Oracle documentation mentions negative impact on performance due to the CLOB column position?
Assuming my table has more than 100 columns and several CLOB columns. The above example is just a simplified version.
Thanks in advance,
Sha
0