Vishwajit
SSC Veteran
Points: 276
More actions
April 10, 2009 at 7:13 am
#130006
Can anybody tell me how to optimize lookup transformation.
Thanks
Tim Mitchell
SSCoach
Points: 15681
April 12, 2009 at 8:50 pm
#976369
Retrieve fewer columns by using SELECT [column1], [column2], etc, rather than SELECT *. Appropriate indexes will help as well.
For better answers to your questions, include more detail about your scenario and what you've tried so far.
Tim Mitchell, Microsoft Data Platform MVPData Warehouse and ETL ConsultantTimMitchell.net | @Tim_Mitchell | Tyleris.comETL Best Practices
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply