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 |
|
WoodHouse
Posting Yak Master
211 Posts |
 Posted - 2010-05-28 : 05:01:56
|
| HiWe have two tables Account_Tran_Detail and Account_Type_Hd.Account_Tran_detail its in ORACLE Database server and Account_type_Hd it’s in SQL SERVER Database.We have created ETL like this...Pullout the data from ORACLE database server (Table called Account_Tran_detail).Pullout the data from SQL SERVER database server (Table called Account_type_hd).Combine these two result set using MERGE JOIN (INNER JOIN).For those records only append to FACT_table in SQL SERVER Database server (this server which same having the table called Account_type_Hd).Table Structure Account_type_HdAccount_key_code surrogate key INT indentity(100,1)Account_code_type varchar(8)Source_system varchar(5)Description varchar(50)We have created clustered on Account_key_code column because its primary key column.But in ETL we are not using this column to joining condition (INNER JOIN).In Joining condition we are using Account_code_type but this column having no index.Same as it in ORACLE Database table Account_Tran_detail. This table not having index in Account_code_type column (this column we joined to sql server table called Account_type_Hd).Please give suggestion to which index we have to create in those two columns.Please explain me why.. its would be helpful for us to great understand Thankswood |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-05-29 : 12:23:01
|
| hi,on which platform are you doing this joins?i suggest you to create nonclustered index on columns that you are creating join.besides that, use statistics in order to track changes in performance and/or use query plan (sql2005+) to detect bottlenecks. |
 |
|
|
WoodHouse
Posting Yak Master
211 Posts |
Posted - 2010-06-01 : 02:13:46
|
| we are using SQL SERVER 2005Thanks |
|
|
|
|
|
|
Index Help