Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2013-03-13 : 10:46:11
|
| hiwe 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_IDwe are fetching the incremental data based on this key fileldsample output for those key fiedld data.here entity id=KM5265569ENTITY_TYPE ='ACCNT'INTEREST_IND ='D'INTEREST_TYPE='P'SERIAL_NUM =00016BANK_ID =01-----------------------KM5265569ACCNTDP0001601KM5269289ACCNTDN0001601KM5269289ACCNTDP0001601KM5275379ACCNTDN0001601--------------------ENTITTY TYPE AVAILBLE IN DATABSE ONLY 3 TYPES OUT OF 3 TYPES LOCATED 85:10:5 RATIO IN THE DATABASEENTITTY ID AVAILBLE ONLY 2 TYPES OUT OF 3 IS 60:50 RATIOENTITY_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 ??????????/ |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-03-25 : 14:37:02
|
| Table partitioning is pretty different between oracle and sql server. So there may not be a directly comparable solution. Have you read up on Partitioned Tables and Indexes from the MSDN library?Be One with the OptimizerTG |
 |
|
|
|
|
|
Table partition in SQL server 2008??