Hi everybody,
I need to know the Performance issue while keeping columns in jumbled up position OR in sequence when we create a Table ? [Database 11gR2]
See the following example :
Designing columns in haphazard way -
create table abc
(a number(6) not null ,
e varchar2(5) ,
g date ,
c date not null ,
x varchar2(40)
) ;
Designing columns in sequence ("not null" first, then all "null" columns) -
create table abc
(a number(6) not null ,
c date not null ,
e varchar2(5) ,
g date ,
x varchar2(40)
) ;
I have read "blocks" will be populated in such a way, that Oracle has to read more bytes (in haphazard design) to go to next record, while less bytes has to be read for sequence desgin. If that is so, then Performance would be affected !!!
Please draw some light on this.
Thanks.
Sarkar