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: 15685
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 MitchellTimMitchell.net | @tmitch.net | Tyleris.comETL Best Practices
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply