|
kond.mohan
Posting Yak Master
India
135 Posts |
 Posted - 03/13/2013 : 10:46:11
|
hi
we are Pulling the data from oracle to SQL server(Staging area).
one of my table having 260 millons of data.we need to do the table partition on this table because table impacting on performace issue.
my table primary key is :
ENTITY_ID + ENTITY_TYPE + INTEREST_IND + INTEREST_TYPE + SERIAL_NUM + BANK_ID
we are fetching the incremental data based on this key fileld
sample output for those key fiedld data.
here entity id=KM5265569
ENTITY_TYPE ='ACCNT'
INTEREST_IND ='D'
INTEREST_TYPE='P'
SERIAL_NUM =00016
BANK_ID =01
-----------------------
KM5265569ACCNTDP0001601
KM5269289ACCNTDN0001601
KM5269289ACCNTDP0001601
KM5275379ACCNTDN0001601
--------------------
ENTITTY TYPE AVAILBLE IN DATABSE ONLY 3 TYPES OUT OF 3 TYPES LOCATED 85:10:5 RATIO IN THE DATABASE
ENTITTY ID AVAILBLE ONLY 2 TYPES OUT OF 3 IS 60:50 RATIO
ENTITY_ID,ENTITY_TYPE,INTEREST_IND HAD IN THE WHERE CLAUSES IN MY SELECT CRITERIA OF FEW REPROTS.
same table has been partitioned 30 parts in ORACLE partition.
how can we compare table partition with oracle.
pls provide the solution for this and using without date field how can we proceed ?
?????????/
|
Edited by - kond.mohan on 03/25/2013 11:05:22
|
|
Table partition in SQL server 2008??
