SQL Language (MOSC)

MOSC Banner

clob column position impact

edited Oct 6, 2011 5:44AM in SQL Language (MOSC) 3 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center