SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Table partition in SQL server 2008??
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kond.mohan
Posting Yak Master

India
196 Posts

Posted - 03/13/2013 :  10:46:11  Show Profile  Reply with Quote
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

TG
Flowing Fount of Yak Knowledge

USA
6062 Posts

Posted - 03/25/2013 :  14:37:02  Show Profile  Reply with Quote
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 Optimizer
TG
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000