I am just curious to know what difference it will make if I created partitioned tables in the following fashhion.
PLAN A
======
create table tab_zz
(
col_a number(2),
col_b char(2)
)
tablespace users
partition by range (col_a)
(<B>
partition part1 values less than (11),
partition part2 values less than (21)</B>
);
PLAN B
======
create table tab_zz
(
col_a number(2),
col_b char(2)
)
tablespace users
partition by range (col_a)
( <b>
partition part1 values less than ('11'),
partition part2 values less than ('21')</B>
);
The ONLY difference in the tables are the way the partition is set. Look at 'partition part1 values less than..' syntax.
Now the questions are:
1. Which is the correct syntax ? (my answer Plan A)
2. Can Plan B syntax be less efficient in the sense that partition range col_a is set as a striing ? ( this is where I have the doubt)
3. Or will there be no difference as Oracle takes care of it internally ?
Any feedbacks welcome. Mahesh ??
] 
Blog
Search
Help
Members
Register
Login
Home
