Skip to content

Instantly share code, notes, and snippets.

@terrancesnyder

terrancesnyder/oracle-hash-sampling.sql

Created February 3, 2012 18:33
Show Gist options
  • Save terrancesnyder/1731629 to your computer and use it in GitHub Desktop.
Save terrancesnyder/1731629 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle Hash Partitioning
Raw
oracle-hash-sampling.sql
select
MYID
, ora_hash(MYID, 100)
from mytable
where
ora_hash(MYID, 100) = 90; -- find everything that goes into bucket 90...
-- ora_hash(MYID, 100) => [BUCKET TO ASSIGNED]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment