infdeveloper
Programmer
Hello every one,
We have a hash partitioned table partitioned on columna and each partiton holds only 1 value
ex: p1=x
p2=y
My question is would there be a difference in performance if table is acessed
select * from table a partition(p1)
vs
select * from table a columna=x
It would be great if some one could give me the performance in this cases
Thanks
We have a hash partitioned table partitioned on columna and each partiton holds only 1 value
ex: p1=x
p2=y
My question is would there be a difference in performance if table is acessed
select * from table a partition(p1)
vs
select * from table a columna=x
It would be great if some one could give me the performance in this cases
Thanks