Link to home
Start Free TrialLog in
Avatar of msimons4
msimons4

asked on

Hash Partition

If I have a table with 45 columns what critera should I use to determine which columns to include in the partition by hash clause?
ASKER CERTIFIED SOLUTION
Avatar of Akenathon
Akenathon
Flag of Uruguay image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of msimons4
msimons4

ASKER

I am trying to speed up full table scans. I thought when you hash partition a table you select which columns you want to partition:

CREATE TABLE invoices
(invoice_no    NUMBER NOT NULL,
 invoice_date  DATE   NOT NULL,
 comments      VARCHAR2(500))
PARTITION BY HASH (invoice_no)
(PARTITION invoices_q1 TABLESPACE users,
 PARTITION invoices_q2 TABLESPACE users,
 PARTITION invoices_q3 TABLESPACE users,
 PARTITION invoices_q4 TABLESPACE users);

in this case: PARTITION BY HASH (invoice_no)
If I have 45 columns what do I base which columns to PARTITION BY HASH
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial