Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

select data from a partition

Status
Not open for further replies.

infdeveloper

Programmer
Feb 23, 2005
4
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top